Great info Andrew, does this work on 7?

Yes, we just used this on a 7 box the other day...

Wow...this could be dangerous!

Absolutely very helpful!  Thanks again Andrew.

This would have saved me hours of work, back when Connector had the import bug which was importing resources even when pressing the "Test Import" button... thanks!

Great query, thank you for providing this!

Hi all,

Can someone please let me know where exactly in the .CS file I need to add the SQL query?  I am assuming I would replace the following line with my query like so: 

static public string sql = @"select Guid from vSiteResource";

static public string sql = @"ENTER SQL QUERY HERE";

Just want to make sure I don't somehow delete 260K items and only the 8K I am actually targeting.

Thanks,
Kevin

That is the correct location to specify your SQL query.

Have you tested in 7.0?

I am looking for deleting approx 12000 unmanaged resources which got in during AD import. How do I use this SQL script to remove these clients. Can someone please help in modifying this SQL script with right queries inside which i can just go and run on the SQL server...atleast for few devices 1st.

Thanks in advance !

Regards/Nitin

You mean I should put following query in the script to test deletion of 1 resource before going for big one.

select vc.guid from vcomputer vc where vc.[ismanaged] = 0 and Server = [server name] and IsLocal = 1 where vc.guid = "7BCCA983-4A92-4675-B281-022AC04E03C5 "

is this right query to be put in the script ? or do I have to include few other tables apart from vcomputer in the query?? and will this script remove all relevant entries/links of unmanaged resources ?

Thanks a lot again !

Regards/Nitin

Hi .. i hav modified the script and put the above query to delete one resource. Now want to check how do I run the script as DB is on the separate server and to execute this script i need nscript.exe which is on notification server ...so can I just simply copy nscript.exe on DB server and execute the nscript.exe deleteitems.cs ??

Regards/Nitin

I copied the nscript.exe and nscript.exe.config from NS to db server.. then i tried to execute the abve script and gave me following error... need help !!! to set it right.

D:\Altiris\Altiris_Bulk_delete_script\DeleteItems>nscript.exe DeleteItems-1resource.cs

* The script file "Altiris.Common, Version=6.0.0.0, Culture=neutral, PublicKeyTo ken=d516cb311cfb6e4f" could not be read

============================================
Errors occurred. Press the enter key to exit
============================================

D:\Altiris\Altiris_Bulk_delete_script\DeleteItems>

how do i run from default location of the script which is NS and my DB is on separate box ..will the script automatically connect to remote DB system and execute the script ?

This is great.  It needs lots of red flags and warnings, becuase you could do real damage.  With great power comes great responsibility.

Can also confirm that this works fine on 7.1 SP2; I used it to purge computers created via AD Import.

Hi, I trying to use this but it seems cannot connect our database, as we are using a out of box DB.

Here are the result after the scripts ran:

Jonouil,

I would be sure that you are running the command in an elevated command prompt on the SMP server, preferably using the Application Identity account to logon to the SMP server.  Your query should not specify the database directly; just run it as above; you shouldn't need to have a "USE <database>" command or fully-quality the table references in the query.

Hi KSchroeder,

It is running same as the original script with adding the SQL, and it is running within the server admin command prompt. 

Here is my script:

Problem solved finally, it required to use the application identify to log in the server to perform the task.

But any ideas how to write the SQL if I have a large amount of machines, which i only have the computer names ?

Thanks.

I am trying to delete all the unmanged computers using the following SQL command SELECT Guid FROM vComputer WHERE IsManaged = 0. I am running from the default location of nscript.exe and running under the application user id. The script starts and shows that it will be deleting 491 items (this is the number I expected). After a few minutes, I get the following error:

* The script threw an exception.
Message: Failed to connect to the local NS communications group.

Stack Trace:
============
   at Altiris.NS.Server.GetNSChannel()
   at Altiris.NS.GroupCommunications.NSSharedCache`2..ctor(Int32 maxSize, String
 cacheName, Boolean filtering)
   at Altiris.NS.ItemManagement.Item.EnsureItemCacheExists()
   at Altiris.NS.ItemManagement.Item.GetItemFromCache(Guid itemGuid)
   at Altiris.NS.ItemManagement.Item.GetItemInternal(Guid itemGuid, IEnumerable`
1 accessPermissions, ItemLoadFlags itemLoadFlags)
   at Altiris.NS.ItemManagement.Item.GetItem[T](Guid itemGuid, IEnumerable`1 acc
essPermissions, ItemLoadFlags itemLoadFlags)
   at Altiris.NS.ItemManagement.Item.GetItem[T](Guid itemGuid)
   at Altiris.NS.ItemManagement.Item.GetItem(Guid itemGuid)
   at DeleteItems.DeleteSQLResults(String sql)
   at DeleteItems.Main(String[] args)

============================================
Errors occurred. Press the enter key to exit
============================================

Any ideas?

I had a similar error, but found it was in fact still deleting the computers . Try running again and I think you'll see a lower number. I also tweaked the code to explicitly write the item.name that was deleting and provide the count of deleted items so far instead of a period.