Skip to content

Getting obsolete Software Inventory results.

Featured Replies

Hello, comrades!

I've created the report "Products from .exe files"- and it's working in a strange way.

I.e. I'm looking for SW product '222'. OK, I find it on computers "aaa", "bbb", 'ccc'. Particulary, i find this file at '\\bbb\d$\install\222'.

But on computer 'bbb' drive D have been changed a month ago and there the directory 'd:\Install' not exists at all.

Is there a chance that "Software Inventory" are put to some kind of cache? Any ways do drop the cache?

Thank you in advance!

----------------------------------------------

Script looks like this:

-------------------------------------------------

SELECT DISTINCT

                         SYS.Netbios_Name0, RIGHT(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0, LEN(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0) - 9) AS PrimaryUser, SP.CompanyName, SP.ProductName,

                         MAX(SP.ProductVersion) AS ProductVersion, v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0 AS IPAddress, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileDescription,

                         v_GS_SoftwareFile.FilePath, v_GS_LastSoftwareScan.LastScanDate

FROM            v_GS_SoftwareProduct AS SP INNER JOIN

                         v_R_System AS SYS ON SP.ResourceID = SYS.ResourceID LEFT OUTER JOIN

                         v_GS_SYSTEM_CONSOLE_USAGE ON SYS.ResourceID = v_GS_SYSTEM_CONSOLE_USAGE.ResourceID INNER JOIN

                         v_GS_COMPUTER_SYSTEM ON v_GS_COMPUTER_SYSTEM.ResourceID = SYS.ResourceID INNER JOIN

                         v_FullCollectionMembership AS fcm ON fcm.ResourceID = SYS.ResourceID INNER JOIN

                         v_Collection AS Coll ON Coll.CollectionID = fcm.CollectionID AND Coll.Name = 'All Workstations' INNER JOIN

                         v_GS_NETWORK_ADAPTER_CONFIGURATION ON SYS.ResourceID = v_GS_NETWORK_ADAPTER_CONFIGURATION.ResourceID INNER JOIN

                         v_GS_SoftwareFile ON SP.ProductID = v_GS_SoftwareFile.ProductId INNER JOIN

                         v_GS_LastSoftwareScan ON SYS.ResourceID = v_GS_LastSoftwareScan.ResourceID

WHERE        (SP.CompanyName LIKE '%222%') AND (v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0 IS NOT NULL)

GROUP BY SYS.Netbios_Name0, RIGHT(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0, LEN(v_GS_SYSTEM_CONSOLE_USAGE.TopConsoleUser0) - 9), SP.CompanyName, SP.ProductName,

                         v_GS_NETWORK_ADAPTER_CONFIGURATION.IPAddress0, v_GS_SoftwareFile.FileName, v_GS_SoftwareFile.FileDescription, v_GS_SoftwareFile.FilePath, v_GS_LastSoftwareScan.LastScanDate

 

The important thing to remember about SW inventory is if the computer hits the 4 hour timeout NO results are sent to CM and stale data will continue to existing within the CM db. You will need to review the inventory agent.log to confirm that it is hitting the 4 hour timeout. 

This is one of the reason why SW inventory is useless. 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.