Symantec Developer Group

Using SMC 7.1

I have an Excel file listing of about 100 computers whose locations need to be updated. My suspicion is that the fastest way to get this done is to execute a stored procedure, but I'm very new to Altiris/Symantec Management Console and the database objects are very much still foreign to me. However, I've done some digging around and found a stored procedure called spSetAssetLocation.

Has anyone ever used this method to complete the task with which I've been charged? Does anyone know if I've got the right stored procedure for the job? If so, what are the variables I should be passing in my EXEC statement? I'm assuming @AssetGuidList would be an array of Guids for the computers whose location you'd like to change, @LocationGuid is asking for the Guid identifying the new location to be set, and @AssociatedAsset...no idea!

Thanks in advance for any help you can offer.

I have done this before, and the best way to do it is using Visual Studio (BIDS) on yuor server to import the spreadsheet, and update your database.

1. Open up your Visual Studio or BIDS (Shell version can do it)

2. Create a Business Intelligence Project

3. Create a SSIS bulk import process (.dtsx )

4. Create your control flow

5. Create Data Flow --> here specify the name of the Excel File, TabName, OLEDB Connection, columns to import, destination database, mappings, error controls, etc.

I am sure you can find some tutorial out there on the web regarding Integration Services.

Good luck.

{F1}