Client Management Suite

Ok so we have many custom inventories and all is well.

The other day I was asked if we can just add a new column to an already in place custom inventory. Back in NS6 days it was difficult as you had to create your local file and run it to create the actual custom inventory table. Today you go in and build it in the "Manage Custom Data Classes" section. and reference that in your vbs. That works as well.

I just went in and added a 30th row. Brought up SQL Management Studio and select * from MyTable

and it is there. Looks good!!!!!

but I cant get my custom inventory to populate that field. The vbs creates the .ok file with the information so that is good... logs on server are all kinds of errors...

so can this be done or not? If so I just want to see what else is needed to be done to allow this. If not I have to create a custom inventory/data class for 1 key!!!!

short blerp from it..

c26="04/28/2017 14:08:35" c27="NO" c28="N/A" c29="Riggs DEV Win7x32 VM" hash="aShgvl/T5zi+45ULj8vPPg=="/>

Hi TeleFragger,

Sounds like you've done everything required to update a Custom Dataclass - is it possible you could upload a log file from the SMP so we can see the error occurring?

Logs found at: %programdata%\Symantec\SMP\Logs\

Thanks

i put a ticket in and they said they were shocked i was able to add a clumn. The recommended practice is to delete the sql table and view... then go in and add the column. This will create a new table/view with the added column. We do not wish to do that so we just created a new data class with just one field!

Hi,

Did the support team refer you to any Symantec Articles for the recommended practice? It'd be good to link it to this post for future customers with the same questions. 

Thanks

no actual articles given... just a backend support recommendation...

Hello TeleFragger,

     I dont think we need to delete and re-add the columns.

Whether you tried to add, it and still it doesnt work?

Normally we will create a editable dataclass and if we want to add a new column we will add it over here.

I will have a look next week!!! thanks!

Nice and helpful

thanks..