How to delete computers that have not reported Inventory in days

Products

• Management Platform (Formerly known as Notification Server)

Issue/Introduction

 

Resolution

Question
How can I delete computers from my Notification Server database based on the criteria of not receiving Inventory in a certain amount of time?

Answer

This script is based in the Latest Inventory Date contained in the database for all the computers. By default, this script will delete computers that have not sent Inventory information for the last 30 days. If you want to change the default value of deleting computers that have not reported inventory in 30 days, open the file with notepad and locate the following line:

set @days = 30


Change 30 to the amount of days that you want to delete (for example 45).

This is an NS script and must be run in the Program Files\Altiris\Notification Server\bin folder using the command line: NScript.exe %File_Name.cs%. See the Readme file attached for more details of how to run this script. Change the .txt extension to .cs for the DeleteComputersFromTheNS file in order to run the script.

// Delete Computers that have not reported inventory in 30 days

using System;

using System.Data;

using System.Data.SqlClient;

using System.Collections;

 

using Altiris.NS.Utilities;

using Altiris.NS.ContextManagement;

using Altiris.NS.ItemManagement;

 

class Class1

{

 

            static void Main(string[] args)

            {

                        Altiris.NS.Security.SecurityContextManager.SetContextData();

 

                        using (DatabaseContext context = DatabaseContext.GetContext())

                        {

                                    string sql = @"

                                                            declare @days int

                                                            set @days = 30

                                                            select cr.[Guid], dt.[LatestInventoryDate]

                                                            from [vComputerResource] cr

                                                            inner join (

                                                                        select [ResourceGuid], max([ModifiedDate]) as LatestInventoryDate

                                                                        from dbo.ResourceUpdateSummary

                                                                        group by [ResourceGuid]

                                                                        ) as dt on cr.[Guid] = dt.[ResourceGuid]

                                                            inner join vResourceEx rx on rx.[Guid] = cr.[Guid]

                                                            where rx.[IsManaged] = 1

                                                            and dt.[LatestInventoryDate] < dateadd(dd, @days * -1, getdate())

                                                            order by LatestInventoryDate desc";

 

                                    ArrayList list = new ArrayList();

 

                                    using (IDataReader reader = context.CreateCommand(sql).ExecuteReader())

                                    {

                                                while (reader.Read())

                                                {

                                                            list.Add(reader.GetGuid(0));

                                                }

                                    }

 

                                    IItem item = new Item();

                                    Console.WriteLine("Found " + list.Count + " Resources");

 

                                    foreach (Guid guid in list)

                                    {

                                                try

                                                {

                                                            item = Item.GetItem(guid);

                                                            Console.WriteLine("Deleting " + item.Name);

                                                            item.Delete();

                                                }

                                                catch (Exception ex)

                                                {

                                                            Console.WriteLine("Error deleting " + item.Name);

                                                            Console.WriteLine(ex.Message);

                                                }

                                    }

                        }

            }

}