Systems Management

tolmie,

I haven't got a clue where it's gone - maybe 'someone' deleted it [:)]

Here's the SQL statement if you want to recreate it:

Select sys.Netbios_Name0, fcm.SiteCode, sys.User_Domain0, sys.User_Name0, sys.Operating_System_Name_and0, arp.DisplayName0
FROM v_R_System sys
JOIN v_Add_Remove_Programs arp ON sys.ResourceID = arp.ResourceID
JOIN v_FullCollectionMembership fcm on sys.ResourceID=fcm.ResourceID
WHERE DisplayName0 = @displayname and fcm.CollectionID=@CollID

Thanks,

Dunnpy

Sorry, report is still there but the software item is not available, I assume this is because i had Delete Aged Collected files turned on, this was set for 90 days, is that the problem and how do I get the software selection back?

Cheers

tolmie,

It's the Hardware Collection Agent that collects the Add/Remove Program information - so it's possibly the 'Delete Aged Inventory History' task that you need to be looking at.

I suppose, for example, if your Hardware Inventory Client Agent is only running at 60 day intervals and your 'Delete Aged Inventory History' task is set to 30 days - then you will end up with missing information, until the scan runs again.

Try changing the frequency of hardware inventory to a short interval (daily), and see if the information returns - you can always set it back to something more reasonable afterwards.

Sorry I can't be more help - where I am we have a separate asset/software management tool - so this side of things isn't utilised to a great extent.

Thanks,

Dunnpy

I've now noticed that when I go to pick the software that it says that it's only showing 1000 of 1136 and I'm not sure how to use the wildcards to view the rest, can anyone advise me.

Cheers