PGSQL:
select si1.WORKSTATIONNAME "SERVER" ,si2.WORKSTATIONNAME "WORKSTATION" ,si2.MANUFACTURER "Manufacture",si2.MODEL "Model",si2.SERVICETAG "Service Tag",rr2.SERIALNO "Serial Number",sdo.name "Vendor Name",round(wsmem.totalmemory/(1024*1024*1024),2) "Memory in GB",rr2.WARRANTYEXPIRY "Warranty Expiry",osi.osname "OS" ,pri.cpuname "Processor Name",pri.Processorcount "Processor Count",rr3.resourcename "Associate To" from systeminfo si1 left join resources rr1 on si1.workstationid=rr1.resourceid left join cirelationships cir on cir.ciid=rr1.ciid left join resources rr2 on rr2.ciid=cir.ciid2 left join processorinfo pri on pri.workstationid=rr2.resourceid left join memoryinfo wsmem on wsmem.workstationid=rr2.resourceid left join osinfo osi on osi.workstationid=rr2.resourceid left join SDOrganization sdo on sdo.org_id=rr2.vendorid left join systeminfo si2 on si2.workstationid=rr2.resourceid left join ResourceAssociationHistory rah on rah.RESOURCEID=rr2.RESOURCEID left join resources rr3 on rr3.RESOURCEID=rah.ASSTTORESOURCEID where si1.isserver='true' and si2.isserver='true' order by 1
Regards
vijendra boopathy