Just Published! Threat Report: Exposing Malware in Linux-Based Multi-Cloud Environments | Download Now

How to update multiple computer tags using a SQL script

How to update multiple computer tags using a SQL script

Version

6.0.x, 7.0.x; 7.2.x.

Topic

This document describes how to update multiple computer tags using a SQL script.

Steps

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:

  1. 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"
    1. 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.
    2. Run the query below. You will need full SQL Server administrator permissions in order to run this particular query.

    use das;

    update

    dbo.hostmain

    set

    dbo.hostmain.comment = source.comment

    from

    OPENROWSET('MICROSOFT.JET.OLEDB.4.0','Text;Database=C:\;','SELECT * FROM [ip_to_name_mappings.txt]')

    as

    source,

    dbo.hostmain

    where

    dbo.hostmain.host_id in (

       select Computer_Id

       from bit9_public.ExComputers

       where bit9_public.ExComputers.Ip_Address = source.ip_address

    )

    ;

    Important Note(s)

    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.

    Labels (1)
    Was this article helpful? Yes No
    No ratings
    Article Information
    Author:
    Creation Date:
    ‎12-04-2014
    Views:
    561
    Contributors