I need some help with a SCCM 2012 Query (Im not a SQL guy). Im Trying to create a query to include Server Name, Total of Memory, Hard Drive(s) Letter and Space, Boot Up Time and the applications installed on the servers.
Here is what I have, is working but the report is generating Thousand of pages. Any other way or suggestion to generate what I need using a report or query?
select distinct SMS_R_System.Name, SMS_R_System.IPAddresses, SMS_G_System_OPERATING_SYSTEM.Caption, SMS_G_System_COMPUTER_SYSTEM.Manufacturer, SMS_G_System_OPERATING_SYSTEM.LastBootUpTime, SMS_G_System_INSTALLED_SOFTWARE.ProductName, SMS_G_System_INSTALLED_SOFTWARE.ProductVersion from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId