SQL Query To Retrieve OpsMgr 2007 Machine Information

 

This SQL Query will return the following machine information from the OperationsManager database: Machine Name, Machine Fully Qualified Domain Name (FQDN), IP Address, Active Directory (AD) site, Organizational Unit (OU) name and if the machine is a virtual machine or not.

 

SQL Query:

 

Select   

NetbiosComputerName 'Machine Name',

NetworkName FQDN,

IPAddress 'IP Address',

ActiveDirectorySite 'AD Site',

OrganizationalUnit 'OU Name',

 

'Virtual Machine' = Case

When IsVirtualMachine = 0 Then 'No'

Else 'Yes'

End

 

From Mt_Computer

 

 

 

Published Monday, May 26, 2008 7:39 AM by dhite
Filed under:

Comments

No Comments