Sign in
 
Home2012Previous VersionsLibraryForumsGallery
System Center TechCenter >
> 
> 
Collection based on hardware model not working

Answered Collection based on hardware model not working

  • Tuesday, February 28, 2012 12:12 AM
     
     
    Sign In to Vote
    0

    Hi

    I have created a collection for Dell Latitude laptops:

    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.Model like "%Lat%"

    There is only 10 computers that have been added to this collection. There should be at least 50. I set hardware inventory to run daily about 2 weeks ago but this hasnt helped. If I check resource explorer on a computer that is not a member, the model in computer system is present.

    Any ideas on why computers are not being added to this collection?

    Thanks

    yeah

     

All Replies

  • Tuesday, February 28, 2012 12:16 AM
     
     
    Sign In to Vote
    0
    Run a report on for the model or create a SQL statement to find it.  Also you can take this WQL statment and you can place it in the query node and work on it, rather than doing it in the collection.  

    http://www.sccm-tools.com http://sms-hints-tricks.blogspot.com

     
  • Tuesday, February 28, 2012 12:30 AM
     
     
    Sign In to Vote
    0

    Hi,

    You could use this report:

    http://ccmexec.com/2010/04/sccm-report-count-computer-models-per-collection/

    It will list all models and count per model.

    regards,
    Jörgen

    -- My System Center blog ccmexec.com -- Twitter @ccmexec

     
  • Tuesday, February 28, 2012 12:42 AM
     
     
    Sign In to Vote
    0

    Thanks

    I just ran the report and received the same results as the collection. I also tried running a query and it too returned the same results as the collection.

    Having said all that, I have noticed that a collection that I based on an installed application is also having the same problem - It is only adding a few computers. It's like inventory has stopped.

    Ill start looking at some logs for inventory on the management point.

    yeah

     
  • Tuesday, February 28, 2012 12:55 AM
     
     
    Sign In to Vote
    0

    The log file MP_Hinv.log has not updated since the 14/2/2012.

    Im reviewing the log to see if I can find an issue - however I havent seen any so far.

    yeah

     
  • Tuesday, February 28, 2012 3:42 AM
     
     
    Sign In to Vote
    0
    Im going to open a new thread as the problem is not the collection but the management point failing to process hardware and software inventories.

    yeah

     
  • Tuesday, February 28, 2012 3:53 AM
     
     Answered
    Sign In to Vote
    0

    New thread started:

    http://social.technet.microsoft.com/Forums/en/configmgrgeneral/thread/d659f911-827e-435d-8fbd-771c3e506e35

    yeah

    • Marked As Answer by staino Tuesday, February 28, 2012 3:53 AM
    •