Client Management Suite

Hello,

I was wondering if there are any reports for the following:

1. All Computers with a Symantec Agent
2. All Computers without a Symantec Agent (these would have been manually entered)

Thanks for any help!

If you simply want to know whether a computer has an agent, the easiest way to tell is the "isManaged" field.  When set to 1, it means the SMP management agent is installed.  0 means there is no agent installed.  Common method to have records of unmanaged computers is by using network discovery or AD import.  Depending what solutions you have installed, there are a number of different reports that show this field depending on what other information you need.  Otherwise, you can create a report with what you need. 

For example, create a new SQL report and paste this in to the SQL query pane as a simple way to see what computers are managed and what isn't:

SELECT * FROM vComputer ORDER BY IsManaged

Is Manage is a value which show if the computer is managed or unmanaged.

If the IS manage value is 0 there is a possibility that the computer has the agent installed but not manage (This happens when computer is not turned ON for long time and Purging Maintanance has set to retire the computer)

As of Now you can find Default reports

1. All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

Reports-->All Reports-->Notification Server Management-->Agent-->All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

2. Computers with Agent Installed

Reports-->All Reports-->Notification Server Management-->Agent-->Computers with Agent Installed

When you attempt to perform a push installation of the Agent, it will create a minimal framework for a computer resource which will show up as Unmanaged until the push install is successful and the agent has reported back it's installation status & basic inventory results.

As Joe stated previously, the most common methods are AD import & network discovery, but many people do not realize that the push mechanism will also create unmanaged resources if unsuccessful.

Thank you all very much for the help.

I did notice one thing,, the following report does not return any results,, we have 122 without an agent.  Is this report giving anyone else a problem?

1. All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

Reports-->All Reports-->Notification Server Management-->Agent-->All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

Do the computers have a Windows OS, or is it a non-Windows or "Unknown" OS?

Are these 122 computer are new, What I mean these were never managed.

Or they had agent and later it was removed.

Hello.. these computers do have an OS either Windows 7 or XP.  I believe these computers were discovered through either an AD Import or were manually entered.  The SMP's My First Time Setup page actually displays the 122 computers nicely.  It would just be nice to have a report that can be exported. 

When our partner was out here, we originally looked at the following report with no luck.

1. All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

Reports-->All Reports-->Notification Server Management-->Agent-->All Windows 2000/XP/2003/Vista/2008/7 Computers with no Agent

Please create a report with Raw SQL query and check the output if the 122 machine are listed.

SELECT vc.[Guid] FROM vComputer vc
WHERE
    vc.[Guid] NOT IN
    (
        SELECT DISTINCT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agent
        WHERE agent.[Agent Name]='Altiris Agent' OR agent.[Agent Name]='Altiris eXpress NS Client'
    )
    AND dbo.fnIsSupportedClientOS(vc.[OS Name], vc.[OS Revision]) = 1
    AND (LOWER(vc.[System Type]) like '%win%' or len(vc.[System Type]) = 0)
    AND vc.[IsLocal] = 1
        

Hello Alim,

Yes, it does return the Guid for each of the 122 machines.  Is this a correction to the that report?

I will check the Default report, meanwhile please use the custom report..I will request you to mark the solution as solution..

Thanks and Regards,

Alim Shaikh

Alim, Thanks for the alternate query.  I appreciate all the contributions.