SMS: Delmif.exe Syntax, Description, and Usage

MORE INFORMATION

The following components can be used in the command line:

Example

The following command creates a delete-MIF file for the client with the SMS ID ABC00012:

   delmif  ABC00012
				

The following command creates a delete-MIF file for the client with the Systems Management Server ID ABC00345, and writes the delete-MIF file to D:\Test:

   delmif  ABC00345  d:\test
				

The following command creates a delete-MIF file for each client whose Systems Management Server ID is listed in Del.dat:

   delmif  @del.dat
				

Use the following syntax for a SQL trigger that will automate the execution of Delmif.exe when a computer's inventory is deleted from the Systems Management Server database. Because inventory MIFs flow up the Systems Management Server hierarchy, this will result in the same client inventory being deleted from all primary sites to the top of the Systems Management Server hierarchy.

DELMIF trigger

   create trigger delmachine
   on Machines
   FOR DELETE
   AS
   DECLARE @smsid varchar(255)
   DECLARE tIDs CURSOR FOR
   select  SMSID0
   from    MachineDataHistoryTable m (index = dwMachineID_idx),
   Identification_SPEC i, deleted d
   where   i.datakey = m.SpecificKey and
           GroupKey = 1 and
           m.ArchitectureKey = 5  and
           m.dwMachineID = d.dwMachineID
   open tIDs
   FETCH NEXT
   FROM tIDs
   INTO @smsid
   WHILE (@@fetch_status <> -1)
   BEGIN
      exec master..xp_delmif @smsid, "C:\SMS\site.srv\isvmif.box\"
      FETCH NEXT
      FROM tIDs
      INTO @smsid
   end
   close tIDs
   deallocate tIDs
				

NOTE: It may be necessary to modify the output path the MIF is written to. For more information on this topic, refer to the Systems Management Server Resource Guide included in the BackOffice Resource Kit.