PENDING SCCM CB Software inventory, what a dylema!!

[Manuel]

Hi to all

The major drawback is that software inventory takes a very long long long time to complete
I checked several blogs about this subject for weeks
What can I do to accelerate software inventory tasks?
My only solution is apparently taking Sofware inventory using another product.
But what happend if I only have SCCM CB 1802 to make the softwar e inventory and I do not have any budget

What I have to tune up?, SQL, Folders, disable throthling policy?, what else!
Any comments will be apreciated

 

[Garth]

Ok, I will bite, Why would you ever want a list of all files on a system? It clearly would be 99% full of useless details. For that 1%, using CI is all you need or ever need.

Here is a question for you, What is wrong with APR or AI software inventory?

 

[Manuel]

Hi Garth

Ok, I will bite, Why would you ever want a list of all files on a system?
-->I do not want to. I am checking a SCCM customer's environment

It clearly would be 99% full of useless details.
For that 1%, using CI is all you need or ever need.
--> I totally agree with you

Here is a question for you, What is wrong with APR or AI software inventory?

I like this URL where you explained CI

What is APR acronyms for? Sorry I missed the point

 

[Garth]

oops that is a typo it should have been ARP = Add/Remove Programs.

Yes you can use that blog to detect a file on a computer. It is a great replacement for SW inventory and it take seconds to run.

 

[Manuel]

Thank you Garth. Then ARP will be for Add/Remove Programs.

Do you have any example where you use ARP instead of software inventory? or maybe just to be clear what would be the exact use of it?

Do you have any additional recomendation?

 

[Garth]

I never use SW inventory as you just can't relay on it.

Have you looked at the builtin reports? There are several that use ARP, what don't they give you?

 

[RJONA]

Hey Manuel,

To add to Garth's Point, I usually just use a SQL Query against SCCM instead.

Select Sys.Name0 as 'Computer Name',
ARP.Displayname0 as 'Installed Software'
from v_r_system SYS
left join V_Add_Remove_Programs ARP on ARP.ResourceID=Sys.ResourceID
Where Displayname0 like 'Adobe Reader%'

You can change the "like" in the last line to "=" if you know the exact name of the product. Be Mindful that "like" statements are far more resource hungry than "=" statements to keep "like" statements limited.

 

[Manuel]

That's awasome. In fact, I will try in my laboratory to get clear of what to expect