DB and Tables to be queried for getting details from Active inventory

[winvarma_MCI]

Hi, we are trying to pull the below details from FNMS related to users and devices and any suggestions which DB and tables we need to query from Active inventory to get the below details.

• Name
• Manufacturer
• Model
• Serial number
• Assigned user
• from all active Inventory

Thanks

[ppyrzynski]

Please try below query:

SELECT        cca.ComputerName, cca.Manufacturer, cca.ModelNo, cca.SerialNo, cca.AssignedUserID, cu.UserName
FROM            ComplianceComputerActive AS cca left JOIN
                         ComplianceUser AS cu ON cca.AssignedUserID = cu.ComplianceUserID

[winvarma_MCI]

Hi @ppyrzynski , thanks for the swift quick reply. Need the data from all computers and not only Active one's

[ppyrzynski]

Then:

SELECT 
cc.ComputerName, 
cc.Manufacturer, 
cc.ModelNo, 
cc.SerialNo, 
cc.AssignedUserID, 
cu.UserName
FROM ComplianceComputer AS cc left JOIN
ComplianceUser AS cu ON cc.AssignedUserID = cu.ComplianceUserID