Groupe des Utilisateurs Altiris Suisses et Francophones Group

Environment :

- DS6.9 SP6

- SMP 7.5 SP1

I need to retrieve the Guid from the computer in Symantec_CMDB from a DS job. For this I've used a "replace tokens" instruction with this query :

%#SMP*"SELECT vc.Guid FROM Inv_HW_Chassis ihwc inner join vComputer vc on ihwc._ResourceGuid = vc.Guid where ihwc.

[Serial Number] = '%SERIALNUM%'"%

The result is...blanck (SMP is a custom DataSource declared in DS option). If I replace the "Select vc.Guid" by "Select vc.name" it works perfectly and return the Computername : for me, it's not a problem in the Datasource declaration, neither a syntax error in SQL Statement !?

Can anybody reproduct this tip...and have an idea ?

David

oops, sorry, I miss the notification.

Well, not sure about but I am afraid the GUID is not in this table, I found a few GUID without data.

Can you try with the vComputer table instead ?

You're not the only one that missed this Pascal!!

Not sure what the issue is, but if you just want the NS GUID from a DS6.9 DB then why not use computer.ns_guid ?

Not sure what the issue is, but if you just want the NS GUID from a DS6.9 DB then why not use computer.ns_guid

...because I didn't think about it :-) ! I didn't know this information could be found in express database : thanks to you, it works perfectly and is most simple than the other solution I've found (I've to call a webservice to find the Guid in NS base on computername).

Sorry to understand so late, I was very busy and with this workaround, I was able to make what I want : I put your solution in production today and all is fine.

Mieux vaux tard que jamais ;-)

Absolutely!