Agent Push via Schedule to pcs with no agent..(filter)

Typically when you discover the machine it should get listed in Comp with no Altiris Agent installed.
this is just a discovery
for installing the agent you should have rights to install on client machine.
check the username/password and firewall settings.

Hi thanks for trying to help..

Permissions are fine, No firewall settings..

I can push the agent out manually fine.

I just want to be able to use the schedule and target machines..

Is there a custom filter I can create which may work? I ran the Raw SQL from the the no altiris agents installed in query analyser and it also didn't bring up anything.

If you selected something basic, even using the old views, which are there.. such as

select vc.name, vc.guid
from vcomputer vc
where vc.[ismanaged] = '0'

If that returns no results, there really aren't any new computers in the database.

Hey Jim,

Thats great, that brought up correct results ie pcs with no agent....how would I exclude servers/site servers with for that? Would it be OK to use for an agent rollout schedule?

Not sure why the standard query doesn't just work out of the box..pretty annoying..anyway i've shown the details below.

The Raw SQL I was using was just the standard query that was written in for the filter 'Windows Computers with no Altiris agent installed' - It was the default filter for scheduling the agent push under agent installation. Looks a lot more complicated..obviously because its specifiying for an operating system..however im not sure where it falls over..something tells me its at the WHERE agent.[Agent Name]= part.

SELECT

vc.[Guid] FROM vComputer vcWHERE

vc

.[Guid] NOT IN

(

SELECT agent.[_ResourceGuid] FROM Inv_AeX_AC_Client_Agent agentWHERE agent.[Agent Name]='Altiris eXpress NS Client'

)

AND

(

vc

.[OS Name] LIKE 'Microsoft Windows 2000%' OR vc.[OS Name] LIKE 'Microsoft Windows XP%'

OR vc.[OS Name] LIKE 'Microsoft Server 2003%'

OR vc.[OS Name] LIKE '%2008%'

OR vc.[OS Name] LIKE '%Vista%'

OR LOWER( vc.[OS Name] ) = 'unknown windows'

)

vc

AND ( .[System Type] = 'Win32' OR vc.[System Type] = 'Win64' OR vc.[System Type] = 'win32' OR vc.[System Type] = 'win64'

)

AND vc.[IsLocal] = 1

I was just thinking about that managed option.

If a client has the agent installed, and then removed via the console..will that update the database to say that pc is NOT managed anymore? 

Just a side thought..

and the agent is still installed on the system, it *should* report back in. You just lose the history. There have been varying times in the past where this didn't happen, however most of those issues have been fixed.

Try taking that query and replace the vc.[isLocal] =1 with the vc.[ismanaged] = 0, and check the results. In answer to your other question the "WHERE agent.[Agent Name]='Altiris eXpress NS Client'" is preceded by where Guid is NOT in, which means the agent guid doesn't have that property. If a machine is discovered, be in by Active Directory Import, Domain Discovery  or Network Discovery, it will still be assigned a guid (in most cases). So, if it's in the console, and doesn't have an agent, it would still have a guid, but the guid would NOT be associated with the property "WHERE agent.[Agent Name]='Altiris eXpress NS Client'", meaning it doesn't have the agent installed.

It would be difficult to exclude servers\site servers from the query, because they wouldn't necessarily (unless they have had the agent installed and reported basic inventory, which gives more detail) be recognized by anything other than their OS. Meaning, if they had a particular role,outside of Altiris,  Altiris wouldn't know about it.

Sorry if that sounds complicated, but you are on the right track. Good luck in your testing.