Client Management Suite

 View Only
  • 1.  Wrong data in Resource | Defaults| Computer Link

    Posted Feb 13, 2012 04:34 AM

    Hi

    Resources | Collection | Windows | All Workstations = 10,000

    Resources | Collection | Windows | All Computers =  9,000 

    Resources | Resources | Default | Computer = 7,000  ( it shouldn't be less as it should contain all active and retired computer)

    Why is this discrepency?

    And how to correct it?

    Please reply..!!

    Thanks..!!

     

     

     



  • 2.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 13, 2012 02:29 PM

    All Windows Workstations includes all managed non-Server Windows systems known to the NS.

    All Computers includes all managed computers, regardless of OS, known to the NS.

    Resources > Default > Computer includes all managed and unmanaged computers.

    You are correct -- Default should not show the lowest number.  Are you sure this is the case?  If so, I recommend sharing the SQL used for your collections -- possibly someone has written a custom collection and the SQL behind it is not good.



  • 3.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 14, 2012 02:15 AM

    @mclemson

    Thanks for reply.

    Collections are showing right number of computers.

    but the Resources > Default > Computer is not showing right number of computers.Its very low..Its should be around 17,000, but its not even 7000.

    Can we correct or restore SQL query for  Resources > Default > Computer



  • 4.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 14, 2012 11:38 AM

    Perhaps some of these are virtual machines.  Have you tried checking the Virtual Machine area?

    You cannot change the default view, but you can create a new query for All Computer resources:

    SELECT iName, vr.Guid, vr.IsManaged FROM vResource vr
    JOIN Item i ON i.Guid=vr.Guid
    WHERE ResourceTypeGuid IN (
    SELECT ResourceTypeGuid
    FROM ResourceTypeHierarchy
    WHERE BaseResourceTypeGuid='493435f7-3b17-4c4c-b07f-c23e7ab7781f'
    )



  • 5.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 15, 2012 02:37 AM

    @mclemson

    Thanks for the reply.

    This query is working for me.

    But,  Still how to correct data in  Resources > Default > Computer .

    Because this should also reflect right data.



  • 6.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 15, 2012 01:43 PM

    Are they below in virtual machines?  If not, either someone else on Connect will have to weigh in, or it's a support ticket.  I'm just stumped.  And we're not talking about multiple pages, where you're viewing page 1 or 3 or something?

    Are you viewing the content as an administrator with rights to see all resources?



  • 7.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 16, 2012 03:18 AM

    @mclemson

    Thanks for the reply..!!

    Machines not in the Resources > Default > Computer  list are not virtual machines.

    They are actual machines.

    and yes , I am looking it as administrator.



  • 8.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 16, 2012 12:21 PM

    I'm stumped.  I recommend submitting a support case.  And when you find out, please do share!



  • 9.  RE: Wrong data in Resource | Defaults| Computer Link

    Posted Feb 17, 2012 06:08 AM

    @mclemson

    Thanks for the reply

    I will surely reply solution on this post if I find any.