Removing Old Computers Placed By Resource Discovery Into Database
Updated: 04 Aug 2008 | 5 comments
How will you be able to remove old computers that were placed by resource discovery into the database? This tech tip will tell you how to do so.
The easiest way is to create a collection which shows unmanaged computers for a discovery method. Once the collection is created, review the set of computer resources, then select the needed computers, right-click, and choose Delete.
Run the following SQL query to create this collection:
USE Altiris --Or your database name
select vc.[Guid]
, Name
, IsManaged
from vComputer vc
join Inv_AeX_AC_Discovery dis on dis.[_ResourceGuid] = vc.[Guid]
where dis.[Discovery Method] in ('DomainMembership') AND IsManaged<>'1'
GO
blog entry Filed Under:
About Endpoint Management Community Blog
The Endpoint Management Community Blog is the perfect place to share short, timely insights including product tips, news and other information relevant to the Endpoint Management community. Any authenticated Connect member can contribute to this blog. Filter by:
Blog Tags
Configuring Altiris Client Management Suite Altiris Deployment Solution Symantec Management Platform (Notification Server) Wise Packaging Basics Altiris Server Management Suite Best Practice Compatibility Tip/How to Helpdesk Solution Altiris IT Asset Management Installing Workflow Solution Ghost Solution Suite Windows Reporting Performance Upgrade Features ServiceDesk 7.x Database Agents Dell Management Products
Comments
This fails for me with an
This fails for me with an "Incorrect syntax near "USE". The DB name is correct.
Senior Consultant @ Creative Breakthroughs, Inc. a Symantec Platinum Partner
http://www.cbihome.com/
That's odd, this query
That's odd, this query works perfectly fine for me, even doing copy/paste directly out of the text box.
Did you put ' ' marks around the DB name? If so, remove them that will cause a Syntax error.
change the DB
post the exact syntax you tried. (also make sure there are no funny characters in what you pasted)
also try
USE altiris -- <--change to the altiris db
select top 10 * from item
neil
change the db name?
When you installed Altiris did you set Altiris to use a diferent DB name then the default?
Jonathan Jesse
Director of Training
ITS Partners
Jonathan Jesse Practice Principal ITS Partners
I know this is an old thread,
I know this is an old thread, but in case someone else is referring to it:
To create a new collection in Console 6.5, I did not put the USE DBNAME at all in the 'Enter SQL Directly:' section. The query starts with the Select keyword and everything works for me.
Would you like to reply?
Login or Register to post your comment.