Custom query for domain controller hardware request
Hi,
I've been tinkering with the asset management and I have a report requirement that I can't make from the wizard, so I was wondering if anyone could help with a query?
I have an asset group I have made called "Domain Controllers" and I have put all the workstations (DCs) I want to report on in this group.
I'd like to list the Domain Name, Server Name, Tag Number, CPU, RAM, IP address and then I can export to a .csv file.
I'm using MSSQL Server 2005 and SDP 7 build 7015 so I'm happy to run the query either within SDP or SQL Server Management Studio.
Many thanks in advance,
Dean
I've been tinkering with the asset management and I have a report requirement that I can't make from the wizard, so I was wondering if anyone could help with a query?
I have an asset group I have made called "Domain Controllers" and I have put all the workstations (DCs) I want to report on in this group.
I'd like to list the Domain Name, Server Name, Tag Number, CPU, RAM, IP address and then I can export to a .csv file.
I'm using MSSQL Server 2005 and SDP 7 build 7015 so I'm happy to run the query either within SDP or SQL Server Management Studio.
Many thanks in advance,
Dean