Hi everyone, I was looking to do a report on a bit of software we have installed, I've been using the report for the last weeks to see what pc doesn't have the software and installing it, the report is computers with software in add/remove progroms. When I now go to select the software it isn't even listed so I can't run a report against it, any ideas, don't know why this has suddenly dissapeared.

Cheers
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
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
Answered 03/03/2008 by: dunnpy
Red Belt

Please log in to comment
0
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
Answered 03/03/2008 by: tolmie
Senior Yellow Belt

Please log in to comment
0
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
Answered 03/03/2008 by: dunnpy
Red Belt

Please log in to comment
0
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
Answered 03/04/2008 by: tolmie
Senior Yellow Belt

Please log in to comment
Answer this question or Comment on this question for clarity