Hi,

We have renamed an App-V package which was installed to 100 computers.
Now the colleciton only shows 10 of the 100 computers with that (renamed) App-V package. A collection we created with the old name doesn't show the other computers either.

Please advise.

That sounds like a client side "issue". Are those devices showing the latest inventory information?

Thanks. We have some hundred machines and I don't know to which machines it was installed (that's what I was trying to figure out since I lost that info).

I would like to create a collection of pc's with hardware info older then 7 days but looking for correct syntax

This has a syntax error:

select SMS_G_System_WORKSTATION_STATUS.LastHardwareScan from  SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan < DateAdd(dd,-7,GetDate()

This did the trick, we have hundred pc's (of thousand) which have hardware scan older then 1 week.

select SMS_R_System.ResourceID,SMS_R_System.ResourceType,SMS_R_System.Name,SMS_R_System.SMSUniqueIdentifier,SMS_R_System.ResourceDomainORWorkgroup,SMS_R_System.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select SMS_R_System.Name from SMS_R_System inner join SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_WORKSTATION_STATUS.LastHardwareScan >= DateAdd(dd,-7,GetDate()) )

You would still get it from the advert id won't you  ?

Then again, the App-V package was deployed to about 200 machines. We can now only see 5, 100 machines have old hardware inventory. So guess that old hardware inventory is not the root cause.

Let me tell the whole story.

I had an application which was called "App-V-Chrome", which was deployed to a collection in which were users as well as computers. This application had 2 deployment types, 1 for Windows 7, 1 for Windows 2008.
Result which I did NOT want to: users which were working on terminal servers and logged on to Windows 7 ALSO had google Chrome.

So I renamed "App-V-Chrome" to "App-V-Chrome-Users" with 1 deployment type for Windows 2008 (deployed to user collection ONLY) and created another application "App-V-Chrome-Computers" with 1 deployment type for Windows 7 (deployed to computer collection ONLY).

-

Main goal I want to achieve = make sure "App-V-Chrome" is NOT installed on W7 computers anymore (which aren't member of computer collection Google Chrome). Just want to be really sure this is the right approach. I guess, I still have to check the computers for  "App-V-Chrome-Users" application then remove it there.

Hope you got the picture and I'm seeing it correct too. Please advise.