Loading
Deleting clients from the SnowInventory database

Good afternoon,

We are in the testing phase of Inventory 5. Previously we could call a Snow stored procedure which would delete an inventoried computer within SNOWDB by passing the [ID] from [dbo].[Client] to the stored procedure. We believe that the new SnowInventory database has a similar stored procedure ([inv].[DeleteClients]) however clients needs to be passed to it as XML. Is there a XML template available please to carry out the deletion, as we will be loading data during our testing we want to eradicate quickly, to enable us to test further without going through the standardized deletion process. 

Any help would be much appreciated :-)


  • Community Manager (Flexera Software)

    Dear Vishay, You are correct that there is a similar way to delete computers in Snow Inventory based on the ClientID. You can declare the clients like this (the XML statements are case sensitive):       DECLARE @clients XML = N'<item id="1"/><item id="2"/><item id="3"/><item id="4"/><item id="5"/>'         EXEC inv.DeleteClients @clients Kind regards, Iwan
      • Community Manager (Flexera Software)

        Hi Vishay, Glad to be of help, don't forget to mark the question as correct so it does not stay open. Kind regards, Iwan

Related  Product Forums


                     → Flexera One



                      → Snow Atlas



                      → FlexNet Manager



                      → Snow License Manager



                       → App Broker


       Need help finding an answer?


        Ask a Question →


Loading
Deleting clients from the SnowInventory database