=?iso-8859-1?B?UulmLiA6IHN5c21hc3RlciBpbmZvIFsxODE4XQ==?=

--------------Boundary-00=_3W90QL80000000000000 Content-Type: Multipart/Alternative; boundary="------------Boundary-00=_3W90LVC0000000000000" --------------Boundary-00=_3W90LVC0000000000000 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable see the query :=0D =0D select sysdatabases.name database,=0D sysdbspaces.name dbspace =0D from sysdbspaces,sysdatabases=0D where partdbsnum(sysdatabases.partnum) =3D=0D sysdbspaces.dbsnum =0D =0D =0D -------Message original-------=0D =0D De : Putillo, Mick J=0D Date : mercredi 10 septembre 2003 17:45:00=0D A : ids@iiug.org=0D Sujet : sysmaster info [1818]=0D =0D Hi. I am trying to find a way to get a list of database names and what=0D dbspace they=0D were created in via a query. I'm looking for a query to give me the=0D same result=0D I can get using onmonitor and choosing Status and then Databases.=0D Thanks in advance for any assistance.....mick=0D =0D =0D =0D =0D =0D =2E --------------Boundary-00=_3W90LVC0000000000000 Content-Type: Text/HTML; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; charset=3Diso-8859-= 1"> <META content=3D"IncrediMail 1.0" name=3DGENERATOR> <!--IncrdiXMLRemarkStart> <IncrdiX-Info> <X-FID>FLAVOR00-NONE-0000-0000-000000000000</X-FID> <X-FVER></X-FVER> <X-CNT>;</X-CNT> </IncrdiX-Info> <IncrdiXMLRemarkEnd--> </HEAD> <BODY style=3D"BACKGROUND-POSITION: 0px 0px; FONT-SIZE: 12pt; MARGIN: 5px= 10px 10px; FONT-FAMILY: Arial" bgColor=3D#ffffff background=3D"" scroll=3D= yes ORGYPOS=3D"0" X-FVER=3D"3.0"> <TABLE id=3DINCREDIMAINTABLE cellSpacing=3D0 cellPadding=3D2 width=3D"100= %" border=3D0> <TBODY> <TR> <TD id=3DINCREDITEXTREGION style=3D"FONT-SIZE: 12pt; CURSOR: auto; FONT-F= AMILY: Arial" width=3D"100%"> <DIV>see the query :</DIV> <DIV>&nbsp;</DIV> <DIV><FONT face=3Dr_ansi size=3D2> <P>select sysdatabases.name database,</P> <P>sysdbspaces.name dbspace </P> <P>from sysdbspaces,sysdatabases</P> <P>where partdbsnum(sysdatabases.partnum) =3D</P> <P>sysdbspaces.dbsnum </P></FONT>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV id=3DIncrediOriginalMessage><I>-------Message original-------</I></D= IV> <DIV>&nbsp;</DIV> <DIV id=3Dreceivestrings> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>De :</B></I> <A href=3D"ma= ilto:MickPutillo@chevrontexaco.com">Putillo, Mick J</A></DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>Date :</B></I> mercredi 10= septembre 2003 17:45:00</DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>A :</B></I> <A href=3D"mai= lto:ids@iiug.org">ids@iiug.org</A></DIV> <DIV dir=3Dltr style=3D"FONT-SIZE: 11pt" <i><B>Sujet :</B></I> sysmaster = info [1818]</DIV></DIV> <DIV>&nbsp;</DIV> <DIV>Hi. I am trying to find a way to get a list of database names and wh= at</DIV> <DIV>dbspace they</DIV> <DIV>were created in via a query. I'm looking for a query to give me the<= /DIV> <DIV>same result</DIV> <DIV>I can get using onmonitor and choosing Status and then Databases.</D= IV> <DIV>Thanks in advance for any assistance.....mick</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>&nbsp;</DIV> <DIV>.</DIV></TD></TR> <TR> <TD id=3DINCREDIFOOTER width=3D"100%"> <TABLE cellSpacing=3D0 cellPadding=3D0 width=3D"100%"> <TBODY> <TR> <TD width=3D"100%"></TD> <TD id=3DINCREDISOUND vAlign=3Dbottom align=3Dmiddle></TD> <TD id=3DINCREDIANIM vAlign=3Dbottom align=3Dmiddle></TD></TR></TBODY></T= ABLE></TD></TR></TBODY></TABLE><SPAN id=3DIncrediStamp><SPAN dir=3Dltr><F= ONT face=3D"Arial, Helvetica, sans-serif" size=3D2>______________________= __________________________________________<BR><FONT face=3D"Comic Sans MS= " size=3D2><A href=3D"http://www.incredimail.com/redir.asp?ad_id=3D312&am= p;lang=3D12"><IMG alt=3D"" hspace=3D0 src=3D"cid:A87955BF-58A9-4C51-8A9B-= F723234CE1B3" align=3Dbaseline border=3D0></A>&nbsp; <I>IncrediMail</I> -= <B>La messagerie =E9lectronique a enfin =E9volu=E9</B> - </FONT><A href=3D= "http://www.incredimail.com/redir.asp?ad_id=3D312&amp;lang=3D12"><FONT fa= ce=3D"Times New Roman" size=3D3><B><U>Cliquer ici</U></B></FONT></A></SPA= N></SPAN></FONT></BODY></HTML> --------------Boundary-00=_3W90LVC0000000000000-- --------------Boundary-00=_3W90QL80000000000000 Content-Type: image/gif; name="IMSTP.gif" Content-Transfer-Encoding: base64 Content-ID: <A87955BF-58A9-4C51-8A9B-F723234CE1B3> R0lGODlhFAAPALMIAP9gAM9gAM8vAM9gL/+QL5AvAGAvAP9gL////wAAAAAAAAAAAAAAAAAAAAAA AAAAACH/C05FVFNDQVBFMi4wAwEAAAAh+QQJFAAIACwAAAAAFAAPAAAEVRDJSaudJuudrxlEKI6B URlCUYyjKpgYAKSgOBSCDEuGDKgrAtC3Q/R+hkPJEDgYCjpKr5A8WK9OaPFZwHoPqm3366VKyeRt E30tVVRscMHDqV/u+AgAIfkEBWQACAAsAAAAABQADwAABBIQyUmrvTjrzbv/YCiOZGmeaAQAIfkE CRQACAAsAgABABAADQAABEoQIUOrpXIOwrsPxiQUheeRAgUA49YNhbCqK1kS9grQhXGAhsDBUJgZ AL2Dcqkk7ogFpvRAokSn0p4PO6UIuUsQggSmFjKXdAgRAQAh+QQFCgAIACwAAAAAFAAPAAAEEhDJ Sau9OOvNu/9gKI5kaZ5oBAAh+QQJFAAIACwCAAEAEAANAAAEShAhQ6ulcg7Cuw/GJBSF55ECBQDj 1g2FsKorWRL2CtCFcYCGwMFQmBkAvYNyqSTuiAWm9ECiRKfSng87pQi5SxCCBKYWMpd0CBEBACH5 BAVkAAgALAAAAAAUAA8AAAQSEMlJq7046827/2AojmRpnmgEADs= --------------Boundary-00=_3W90QL80000000000000--