Using SQL to insert customized fields into SW db

scott_frisch

We are adding servers to SW we added some columns to the data base and I want to use SQL to "populate" them using SQL.

SUDO looks like the following

read source file using perl

from there write a for loop to read in the three sql fields

Field one is the server name

field 2 is the customized fieild for billing client

field 3 is the agency that owns the server.

(All this after we have snmp running)

I want to test with out writing to the DB first is this possible and have it be a try test? or do I have to set up a test DB?

If I can do this is there any API that needs to done ?

Please note I am a admin, not a DBA ---

Find more posts tagged with

writes

sql

read

Accepted answers

aLTeReGo

Using the API is not required, but it will likely simplify your implementation and ensure it's forward compatible with future versions of Orion. writing to a custom property field directly via SQL isn't complicated, but I would probably recommend downloading and installing an evaluation on a separate server to perfect your code before executing on your production instance.

All comments

njoylif

off top of my head I would say you'd pull the fields from the loop into a temp table and do a join to the nodes table and just output <tmptbl>.*, nodes.<columnsOfInterest>.

join on temp table server name and node caption or whatever column it was designed to match on.

Once validated, you would just (after backing up DB, of course) update nodes table with billing client and agency columns from temp table where <tmptbl>.<servername> = nodes.<matching column name>

aLTeReGo

Have you considered using Custom Properties and and leverage the Orion SDK/API?

scott_frisch

The API was in question --that is weather you had to access or not. I was thinking of using the Custom Properties since we have created two new fields for ourselves.

1. Is the use of the API required?

2. Would using the API make life easier than doing in certs?

I am going to need some spoon feeding here this is a first for me -- doing SQL

thanks in advance -

scott_frisch

aLTeRGo is indicating to use API is this required ?

aLTeReGo