Sccm software inventory sql

Back on the Default Settings window, click OK to apply all changes. Now all of your clients will be using the most efficient way possible to return results for iexplore. It will still take some time to collect the SW Inv results. Ir al contenido. See how Right Click Tools are changing the way systems are managed.

Immediately boost productivity with our limited, free to use, Community Edition. Get started with Right Click Tools today: download for free. Facebook Twitter LinkedIn Email. Answered by:. Archived Forums. Configuration Manager - General. Post questions here that are not appropriate for the other Configuration Manager specific forums, AND after you have already searched for your answer.

Sign in to vote. Monday, September 12, PM. Jason Sandys has a good script to inventory this information. True, but a namespace and class in WMI are trivial. Worrying about them has no value as they have zero impact. As for VBScript vs.

PowerShell, same reply. If it works, is supported, and meets your requirements, why does it matter at all except to quibble about something that has zero impact. Sherry writes great and useful stuff. As noted, you should use what works, what meets your requirements, and what is supported. However, it seems a bit very really petty to write a comment on a blog post just to say this.

I have no idea what you are referring to here. Does this gather db filenames? Hi Jason, I found that the clustername value your script returns, is always empty. Hi Jason, Thank you for this — I have deployed the script to my clients and results are coming in. This is the query as I have it now. Hi Michael, Sorry for the delay on this. Once again, thank you for this great script! Have the same problem, did you solved it? Hi, The script works wonderfully in sccm r2.

This script is great, Thank you. Your DBAs will know the answer. The data is there, just not sure how to incorporate this info into you report. And Platform, Virtual or Physical. You can also schedule the operation in client settings. After you enable software inventory and the clients run a software inventory cycle, the client sends the information to a management point in the client's site. The management point then forwards the inventory information to the Configuration Manager site server, which stores the information in the site database.

Create queries that return devices with specified files. Create query-based collections that include devices with specified files. Run reports that provide details about files on devices.