Sccm 2012 Software Inventory Report
Jan 03, 2018 Schedule software inventory and file collection schedule - Configures the interval at which clients collect software inventory and files. Configure the client settings that you require. The Software inventory section of the About client settings in System Center Configuration Manager article has a list of the client settings. 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.
Join David M. Franklyn for an in-depth discussion in this video Hardware and software inventory, part of Microsoft System Center Configuration Manager Essential Training. Your reports, or your certificates of completion for this course. System Center Configuration Manager (SCCM) allows an enterprise to manage and deploy applications to all devices in their environment. The product is incredibly powerful and has an astonishing array of features, ranging from endpoint security to application deployment and patching. Among these features, Microsoft also markets software inventory as a provided feature.
Our recommendation is to deploy your applications with SCCM and use StacksWare to track how those applications are utilized to cut license costs and defend against potential audits. How To: Inventory Software in System Center Configuration Manager (SCCM) Step 1: Navigate to the your Client Settings. Create a Software Inventory Reports using PowerShell. Powershell, Powershell Script, Software inventory, aman dhally, Software inventory using powershell. Report abuse to Microsoft. Verified on the following platforms. Windows 10 No. Troubleshooting hardware inventory in SCCM can be a daunting task. Sometimes your hardware inventory cycle tab is missing, other times, the hardware scan is not updating. This step by step guide will help you troubleshoot your SCCM issue.
Inventory Software
Data Doctor Billing and Inventory management software tool track party details and outstanding invoices. Bookkeeping utility preview and print reports and charts like invoice listings, sales, outstanding invoice list.
- Publisher: Data Recovery Directory
- Last updated: July 8th, 2010
ABC Inventory Software
ABC Inventory software is an absolutely free inventory software for small and mid-sized businesses. There is no limit on number of records in the database. There is no limit on a number of workstations, it can be installed on.Basic FeaturesMultiple companiesMultiple Warehouses for a companyMultiple CurrenciesCurrency rates auto-update
- Publisher: Almyta Systems
- Home page:www.almyta.com
- Last updated: July 19th, 2012
Inventoria Inventory Software
With Inventoria you can manage and monitor your inventory to help streamline your operations and boost profits. Use Inventoria Free to easily organize and keep track of inventory. Warnings and reports help ensure you are never out of stock.
- Publisher: NCH Software
- Home page:www.nchsoftware.com
- Last updated: June 3rd, 2014
iMagic Inventory
Managing stock has never been as easy! iMagic Inventory lets you take full control of your inventory and invoicing. Save time, manage customers and get one step ahead of your competition with this inventory software.
- Publisher: iMagic
- Home page:www.iMagicInventorySoftware.com
- Last updated: April 10th, 2017
Network Inventory Advisor
Network Inventory Advisor is an agent-free solution for PC network inventory. It excellently performs remote agentless scanning of Windows, Mac OS X and Linux and builds custom inventory reports.
- Publisher: ClearApps Software
- Home page:www.network-inventory-advisor.com
- Last updated: July 27th, 2019
EMCO Network Inventory Starter
An award-winning network inventory software for organizations of any sizes. It offers features for remote audit of every PC in your network without having to install client modules. By using EMCO Network Inventory you can get detailed hardware, software inventory and licensing information from all remote PCs within seconds.
- Publisher: Emco Software Ltd.
- Home page:emcosoftware.com
- Last updated: April 22nd, 2013
DoInventory Plus
DoInventory™ is your complete asset tracking and inventory software for Blackberry devices, Palm OS or webOS Palm handhelds, Windows Mobile handhelds, and Windows PCs! Inventory your home, office, business, collections, etc. Carry your inventory with you. Supports numerous barcode scanners.
- Publisher: WakefieldSoft, LLC
- Home page:www.wakefieldsoft.com
- Last updated: October 19th, 2011
Codenica Inventory
Codenica Inventory is IT inventory software for managing a company's computers, hardware, software, licenses, and consumable materials. The application makes it possible to easily manage IT assets and record inventoried events, such as repairs, services, upgrades, and maintenance operations.
After a blazing encounter with the ruthless Johnny Tran, Dom decides to take Brian (Paul Walker), a newcomer to street racing, under his wing. Trouble is, neither of them realize he's an undercover cop, and Dominic and his rival Johnny Tran are both the prime suspects in a case involving dirty money and big-rig hijacking.Cast:,Director:Genres:,Production Co: Original Film, Neal H. Dom's sister Mia sees something she likes in Brian, too. Based onRelease Date:DVD Release Date:PG-13 1 hr 47 minFollow the movie onPlot SummaryDominic Toretto (Vin Diesel) enjoys the adrenaline of street car racing and his fans treat him like a rock star. Download fast and the furious 2001 free.
- Publisher: Codenica
- Last updated: September 11th, 2011
iMagic Inventory Software
Managing stock has never been as easy! iMagic Inventory lets you take full control of your inventory and invoicing. Save time, manage customers and get one step ahead of your competition with this inventory software.
- Publisher: iMagic
- Home page:www.iMagicInventorySoftware.com
- Last updated: January 27th, 2017
TweakNow PowerPack 2012
TweakNow PowerPack 2012 is a fully-integrated suite of utilities that let you fine-tune every aspect of your computer's operating system and Web browser. The suite also gives you a complete picture of all aspects of your computer's hardware, including detailed information about your motherboard, processor, video card, memory, hard disk and network.
- Publisher: TweakNow
- Last updated: April 18th, 2013
Aurora 3D Presentation 2012
Aurora 3D Presentation 2012 allows your creative imagination to easily compose stunning 3D Interactive, Video and Multimedia Programs. You can quickly design business and touch screen interactive presentations, 3D product shows, 3D animation videos and other multimedia, export to EXE or video files.
- Publisher: Aurora3D Software Co. Ltd.
- Home page:www.presentation-3d.com
- Last updated: February 12th, 2015
ABC Inventory
This MRP II application has been designed to handle every aspect of inventory management, providing the ability to track each step in the inventory life cycle from the time you create a purchase order for your supplier to the moment you ship the product to your customer.
- Publisher: Almyta Systems
- Home page:www.almyta.com
- Last updated: September 11th, 2012
Bitdefender Antivirus Plus 2012
Bitdefender is based on a detection system based on behavioral technologies, studied in virtualized environment, and cloud services to stop threats in real time. Autopilot feature ensures trouble-free experience, taking the best decisions about security, without requiring your intervention. This means that they will not be displayed pop-ups, alerts, you will not need to configure anything.
- Publisher: BitDefender
- Home page:www.bitdefender.com
- Last updated: January 15th, 2013
Nsasoft Hardware Software Inventory
Nsasoft Hardware Software Inventory is comprehensive and efficient network inventory software for home, office and enterprise networks. The software scans all computers on a network and generates complete reports about computers hardware and software. This information is added to the centralized database and then users can generate reports about each or all of the PCs on a network.
- Publisher: Nsasoft US LLC
- Home page:www.nsauditor.com
- Last updated: July 3rd, 2014
Inventory
A simple software for small and medium-sized business. With this program you can check everything there is about your products, like: sales report, production report, cost, where is the product in the warehouse, inventory list with all the products, and everything there is to know about them.
- Publisher: Distribution Hiven Enr.
- Last updated: April 10th, 2008
NVIDIA nTune
SIW is an advanced System Information for Windows tool that analyzes your computer and gathers detailed information about system properties and settings and displays it in an extremely comprehensible manner.SIW can create a report file (CSV, HTML, TXT or XML), and is able to run in batch mode
- Publisher: Topala Software Solutions
- Home page:www.gtopala.com
- Last updated: August 29th, 2011
AIDA64 Business Edition
AIDA64 Business can collect detailed hardware and software inventory from Windows client computers connected to the corporate network. Using command-line switches, creating inventories can be fully automated, while reports collected from the PCs can be saved to open formats ready for further processing, or sent to SQL databases.
- Publisher: FinalWire Ltd.
- Home page:www.aida64.com
- Last updated: October 3rd, 2019
Global Network Inventory
Global Network Inventory is a powerful and flexible software and hardware inventory system that can be used as an audit scanner in an agent-free and zero deployment environments. Global Network Inventory can audit remote computers and even network appliances, including switches, network printers and document centers. You can also schedule inventory scans to run at specified time.
- Publisher: Magneto Software
- Home page:www.magnetosoft.com
- Last updated: September 6th, 2012
The requirement of the software inventory to function is similar to that of the hardware inventory. The process is also almost similar.
Client Side
The scheduler will send a message to the inventory agent to start the software inventory process.
Scheduler.log:
Sending message for schedule 'Machine/{00000000-0000-0000-0000-000000000002}' (Target: 'direct:InventoryAgent', Name: ')Scheduler4/10/2005 9:39:06 AM3904 (0x0F40)
The agent will determine the type of inventory it has to process (Full, Delta, Resync).The Scan Properties are stored in WMI at the RootCCMPolicyMachine namespace.
If you don’t see this, the issue can be the client unable to download the policies or the server has not been configured for Software Inventory.
Once the Software Inventory Client Agent has determined its Scan type, it must now determine precisely what it needs to inventory. This is accomplished by again pulling configuration data from WMI. Software Inventory Rule information (what an administrator has configured SCCM to inventory) is stored within the same namespace of WMI (RootCCMPolicyMachine) Each rule is stored in an instance of this class.
The inventory agent will scan the machine according to the software inventory rules and will send an XML file to the software inventory endpoint.
Once the properties of the scan have been determined, and the Advanced Client knows what type of scan (Full, Delta or Resync) to perform, as well as what it is scanning for (as defined in the Software Inventory Rules), it is time for it to perform the actual scan.
Inventoryagent.log
Inventory: *********************** Start of message processing. ***********************InventoryAgent4/22/2010 12:07:36 AM2924 (0x0B6C)
Inventory: Message type is InventoryActionInventoryAgent4/22/2010 12:07:36 AM2924 (0x0B6C)
Inventory: Temp directory = C:WINDOWSsystem32CCMInventoryTempInventoryAgent4/22/2010 12:07:36 AM2924 (0x0B6C)
Inventory: Clearing old collected files.InventoryAgent4/22/2010 12:07:36 AM2924 (0x0B6C)
Inventory: Opening store for action {00000000-0000-0000-0000-000000000002} ..InventoryAgent4/22/2010 12:07:37 AM2924 (0x0B6C)
Inventory: Action=Software ReportType=DeltaInventoryAgent4/22/2010 12:07:56 AM2924 (0x0B6C)
Inventory: Initialization completed in 19.849 secondsInventoryAgent4/22/2010 12:07:56 AM2924 (0x0B6C)
Collection: Input context, scan rate in milliseconds = 2InventoryAgent4/22/2010 12:09:57 AM3972 (0x0F84)
Collection: Input context, skip file name = skpswi.datInventoryAgent4/22/2010 12:09:57 AM3972 (0x0F84)
Collection: Namespace = .rootccminvagt; Query = SELECT Name, Path, LastWriteDate, Size, CompanyName, ProductName, ProductVersion, ProductLanguage, FileVersion, FileDescription FROM FileSystemFile WHERE Name = '*.exe' AND Path = '**' AND IsCompressed = FALSE AND IsEncrypted = FALSE; Timeout = 14400 secs.InventoryAgent4/22/2010 12:09:57 AM3972 (0x0F84)
……………………………
……………………………
………………………….
Inventory: Starting reporting task.InventoryAgent4/22/2010 12:16:19 AM2384 (0x0950)
Reporting: 0 report entries created.InventoryAgent4/22/2010 12:16:20 AM2384 (0x0950)
Inventory: Reporting Task completed in 0.931 secondsInventoryAgent4/22/2010 12:16:20 AM2384 (0x0950)
Inventory: Successfully sent report. Destination:mp:MP_SinvEndpoint, ID: {EBC09961-66DD-4C98-9656-FA370C3259BC}, Timeout: 80640 minutes MsgMode: Signed, Not EncryptedInventoryAgent4/22/2010 12:16:20 AM2384 (0x0950)
Inventory: Cycle completed in 541.088 secondsInventoryAgent4/22/2010 12:16:37 AM2384 (0x0950)
Inventory: Action completed.InventoryAgent4/22/2010 12:16:37 AM2384 (0x0950)
Inventory: ************************ End of message processing. ************************InventoryAgent4/22/2010 12:16:37 AM2384 (0x0950)
If there are some failures there then you can check to make sure that the consistency of the WMI and client of the system. Also we have information on
FileSystemFile.log
************* Start of File System Query. *************FileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Query = SELECT __class, __path, __relpath, name, path, lastwritedate, size, companyname, productname, productversion, productlanguage, fileversion, filedescriptionFROM FileSystemFile WHERE name = '*.exe' and path = '**' and iscompressed = false and isencrypted = false; Timeout = 14400 secs; ScanInterval = 2 msecs; SkipFile = skpswi.datFileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Query parsed successfully.. ready to scan for files.FileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Folders to skip: c:system volume information.FileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Scanning all local drives using input path *FileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Skipping A:;GetDriveType indicates it is not a fixed drive pathFileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Sccm 2012 Software Inventory Report Format
Scanning C: ..FileSystemFile4/22/2010 12:09:57 AM2384 (0x0950)
Skipping directory c:system volume informationFileSystemFile4/22/2010 12:11:49 AM2384 (0x0950)
Skipping directory c:system volume informationFileSystemFile4/22/2010 12:11:49 AM2384 (0x0950)
Excluding C:WINDOWS$NtUninstallKB923845$ (compressed)FileSystemFile4/22/2010 12:11:59 AM2384 (0x0950)
Excluding C:WINDOWS$NtUninstallKB923845$ (compressed)FileSystemFile4/22/2010 12:11:59 AM2384 (0x0950)
Once the scan based on software inventory rules is completed, the results are stored within WMI on the Advanced Client
Server Side
The Management Point receives the message from the Advanced Client via a CCM_POST request. This allows the client to upload the message to the C:SMS_CCMServiceDataMessagingEndpointQueuesMP_SinvEndpoint directory on the Management Point.
Once there, CCMExec on the Management Point processes the message to recreate the XML file. This file is then stored in the <SEREVERDIR>[1]MPOutboxesSinv.box folder. Once the Management Point has properly received the message and converted it into an XML file for processing, the XML file is then parsed and used to create a .SIC or .SID file. If the inventory data in the XML file is a Delta, the XML file is used to generate a .SID file. On the other hand, if the XML file is complete inventory information, a .SIC file is created.
Mp_sinv.log:
Mp Message Handler: copying attachment to C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment8920FQG5.xmlMP_SinvEndpoint1/31/2010 9:49:55 AM3548 (0x0DDC)
Inv-Sinv Task: processing xml file 'C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment8920FQG5.xml'MP_SinvEndpoint1/31/2010 9:49:55 AM3280 (0x0CD0)
Sccm Hardware And Software Inventory
Sinv Sax: loading C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment8920FQG5.xmlMP_SinvEndpoint1/31/2010 9:49:55 AM3280 (0x0CD0)
Full report from client SQL, action description = SoftwareMP_SinvEndpoint1/31/2010 9:49:55 AM3280 (0x0CD0)
Sinv Task: Translate report attachment to file 'C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.box9GY0JSG8.SIC' returned 0MP_SinvEndpoint1/31/2010 9:49:55 AM3280 (0x0CD0)
Mp Message Handler: copying attachment to C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment4L7OW9WF.xmlMP_SinvEndpoint2/19/2010 7:37:16 PM5980 (0x175C)
Inv-Sinv Task: processing xml file 'C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment4L7OW9WF.xml'MP_SinvEndpoint2/19/2010 7:37:16 PM272 (0x0110)
Sinv Sax: loading C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxSinvAttachment4L7OW9WF.xmlMP_SinvEndpoint2/19/2010 7:37:16 PM272 (0x0110)
Sinv Task: Translate report attachment to file 'C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxAN46DUDY.SIC' returned 0MP_SinvEndpoint1/31/2010 9:36:45 AM4812 (0x12CC)
The management point file dispatch manager copies the file to the site server. There the software inventory processor inserts the data into the database.
Sinvproc.log:
Process Inventory Files..SMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:13 AM5208 (0x1458)
Processing file: C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxW06N50OM.SICSMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:13 AM4668 (0x123C)
Processing Inventory for Machine: SCCMResId: 3 [OpCode=17 Sinv=1 FC=0 Resync=1] Generated: 01/31/2010 09:27:02SMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:37 AM4668 (0x123C)
Transactions: Exist=0, Add=1196, Upd=0, Del=0, Total=1196SMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:37 AM4668 (0x123C)
Report for Machine SCCM took 27 secs. for 2290 recs, FP=109, P=985, F=1196, FC=0SMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:40 AM4668 (0x123C)
Successfully Processed file C:Program FilesMicrosoft Configuration Managerinboxesauthsinv.boxW06N50OM.SIC !!!SMS_SOFTWARE_INVENTORY_PROCESSOR1/31/2010 9:27:40 AM4668 (0x123C)
If the files are not getting processed then we need to make sure that the component SMS_SOFTWARE_INVENTORY_PROCESSOR. In certain circumstances a site reset can also help.
Links
http://technet.microsoft.com/en-us/library/bb693889.aspx : Overview of Inventory
http://technet.microsoft.com/en-us/library/bb632359.aspx:Troubleshooting Inventory
[1] <SERVERDIR> :Program FilesMicrosoft Configuration Manageror <Drive>SMS