Server to Server Relationship Report

Server to Server Relationship Report

Server to Server Relationship Report

Go to Reports Tab--> New Query Report and use the below query

MSSQL:


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


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
              New to ADManager Plus?

                New to ADSelfService Plus?