Enabled Software Inventory on Default Client Settings, 'Enabled software Inventory on clients' and added.exe to the 'Inventory these file types' 3. Verified that all clients are successfully 'talking properly' to the SCCM server. Ran a full 'Software Inventory Cycle' and a 'Hardware Inventory Cycle' client-side on all client computers. I need some help with a SCCM 2012 Query (Im not a SQL guy). SCCM 2012 Full Inventory and Software Query. SCCM 2012 R2 not registering clients. We can use SCCM 2012 R2 software inventory to collect file(ex.exe,.log) file in the client computer. To enable the software inventory on the client computers we have to use client settings, but we don’t want to trigger this scan process on all of your computers.
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
Apr 28, 2016 Pull Hardware Inventory Reports from SCCM 2012 R2. Pull Hardware Inventory Reports from SCCM 2012 R2. Skip navigation. How to Deploy Software Updates Using Microsoft SCCM. My setup: SCCM 2012 R2 installed on a Server 2012 R2 Standard OS, VM Environment, and SQL is installed on a separate server running SQL 2008 R2. Enable Software Inventory in Client Settings, added Inventory these file types '.exe,.dll,.pst', schedule software inventory and file collection every 7 days. We are new to SCCM 2012. We have the hardware and software inventory cycles set to 3 days and have verified we are looking for.exe on all machines. The software inventory seems to have run a few times but now only runs on a few machines almost randomly. Here is a quick Step-By-Step in regards to forcing a full System Center 2012 (or 2007) Configuration Manager inventory cycle on a client PC. Open wbemtest as an elevated administrator. Click Connect. In the Namespace text box enter root ccm invagt, then click Connect. Click Enum Classes. Select Recursive then click OK.
How To Install Sccm 2012 R2
1 Answer
Based on your query, I think this is a normal behavior. Supposing you have 100 computers, and each has 30 software. Then 3000(300*10) records will be returned back in all.
I recommend you divide the query into two parts, one includes Server Name, Total of Memory etc., and the other includes the applications installed on each server.
Besides, you could also use the built-in report 'Products on a specific computer' to view the information.
MonitoringOverviewReportingReportsSoftware - Companies and Products