How can I know what computers don't have a Last Configuration Request date?

book

Article ID: 184142

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Resolution

Question
How can I find out what computers in my environment don't have a Last Configuration Request date besides using the report "Clients with no configuration in last N days" located in Reports tab > Notification Server Infrastructure > Agent > Configuration Request?

Answer

You can run the following query on Query Analyzer or use it to create a report:

select i.[name]
  from vitem i

 where i.guid not in
              (
                select distinct resourceguid
                  from evt_ns_client_config_request
              )

       --This verifies that the item we are finding is a computer resource.
       and i.classguid like '539626D8-A35A-47EB-8B4A-64D3DA110D01'

       --This section is checking to make sure that we are not including servers.
       and i.guid not in
              (
                select distinct _resourceguid
                  from inv_aex_ac_identification
                 where [os type] like '%server%'
              )

       --This section is looking for an agent to be on the machine
       --If the results are not correct you may want to remove this.
       and i.guid in
              (
                select distinct _resourceguid
                  from Inv_AeX_AC_Client_Agent
                 where [agent name] like 'Altiris Agent'
              )

order by i.name