How to update multiple computer tags using a SQL script
6.0.x, 7.0.x; 7.2.x.
This document describes how to update multiple computer tags using a SQL script.
You can use the "Computer Tag" field in the properties of Computer objects to help organize and manage your Bit9 agent installation. In this example, we will map the IP address of a given computer to the Computer Tag for that computer:
Create a plain text file for the mappings. It must have comma-delimited rows, with quotes enclosing the values, and a column header row. Here is an example of the contents of such a file: ip_address,comment "192.168.16.5","Baltimore Register 1" "192.168.7.80","Philadelphia Register 2"
Name this file "ip_to_name_mappings.txt". Then place it at the root of the C: drive, on the SQL Server where the Bit9 database is. You cannot place this file on some other server or workstation.
Run the query below. You will need full SQL Server administrator permissions in order to run this particular query.
dbo.hostmain.comment = source.comment
OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [ip_to_name_mappings.txt]')
dbo.hostmain.host_id in (
where bit9_public.ExComputers.Ip_Address = source.ip_address
The SQL query requires your DBA to enable "Ad Hoc Distributed Queries." Check with your SQL Server administrator about setting these permissions before you run the script.