Use information from deployment server in Notification Server

Eisenkarl's picture

Hi,

i've the following problem.

We use for the OS-Deployment the Deploymentserver and we will us for the installation of the Applications the Software Delivery Solution from the NS.
In the DS we edit the information for Username, Telephone,  Site, Department... (Computer properties/Location)
Based on this informations we will control the Software Delivery process in the NS. That means, if the Client has the entry in the department like "accounting" this information will be used in the NS to push the applications for the department "accounting" to the computer by SWD-Tasks

Unfortunately the Department entry is located in the "express" database (Table: location). The NS use the "Altiris" database. If I install the Delpoyment Solution for NS some informations will be transferred between the express and the Altiris-Database, but not the location entry

How is it possible to get acces to the department entry in the express-database from the NS. Based on these entry we will create collections to assign the appropriate SWD-Tasks.

Can anybody help me with an SQL-Query to build the collection?

regards

Eisenkarl

MBHarmon's picture

Connector Solution & Asset?

Do you have Asset Management Solution and Connector?

If you do it will be quite easy to complete the import using Connector.  I could probably detail that for you if you have those solutions.

- Matt

Eisenkarl's picture

Hi MBHarmon, no we don'T have

Hi MBHarmon,

no we don'T have the Asset Management Solution. So we can't use the connector.

But perhaps it is interesting for other to see the way to solve this with the connector solution.

Do you have an idea to solve this problem by an sql statement?

Regards

Eisenkarl

jmervyn's picture

Same problem

I've been looking over a year for something similar.