Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 1228 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Scripted Endpoint Deletetion

SneakyPete
I would like to be able to remove an individual computer from the database via script. If it is a command line tool or a call to a stored procedure makes no difference to me. The reason for this is to eliminate any chance of machine duplication in the database as machines are reimaged. Would anyone be able to provide some guidance/examples/links to documentation? The initial task will be done in VBScript with a probable migration to C# in the future (because I know VBScript now and not C# yet). Thanks in advance for your assistance!
:38195


This thread was automatically locked due to age.
Parents
  • 0

    Hello SneakyPete,

    first of all, fiddling with the database (on your own) is unsupported - thus there is no documentation.

    Not discussing the details of reimaging and how likely it may cause issues, removing a computer from the database is a simple SQL DELETE. Note that the events and alerts associated with this computer will also be removed during this process. The crucial point is, naturally, to do it for the correct entries. I'd suggest you take a look on the threads for delete from computersanddeletedcomputers (especially note the difference between the ID and Name columns in the table). Feel free to ask if you have more questions.

    Christian

    :38223
Reply
  • 0

    Hello SneakyPete,

    first of all, fiddling with the database (on your own) is unsupported - thus there is no documentation.

    Not discussing the details of reimaging and how likely it may cause issues, removing a computer from the database is a simple SQL DELETE. Note that the events and alerts associated with this computer will also be removed during this process. The crucial point is, naturally, to do it for the correct entries. I'd suggest you take a look on the threads for delete from computersanddeletedcomputers (especially note the difference between the ID and Name columns in the table). Feel free to ask if you have more questions.

    Christian

    :38223
Children
No Data