NW Updater for 1E's Nightwatchman

The company that I work for use 1E's Nightwatchman service for shutting down and waking up computers for the purpose of power saving and having greener credentials as a corporation. The service itself is great and does an amazing job of keeping our machines in a state to save energy etc and to enable us to wake up the machines in order for staff to be able to get to their desk in the morning and find their pc ready and waiting for them to login.

However I have one issue with Nightwatchman and that is its managemnet console and scripts used for adding machines to the Nightwatchman database. Obviously you could use custom scripts instead of those supplied but i thought it would be beneficial to have an application which does all of the work for you behind the scenes.

The main problems i see are that you have to compile a csv file with a list of 5 tiers and the Active Directory OU of where the computers reside. This can be very tedious and time consuming to create and update if you change things (or management want to change things) such as the tier structure or names.

So as I see it I want to be able to take an existing csv file of the tier structure import it into a datagridview. This will then ebale you to edit the fields/tiers in a more manageble fashion. From this you can then do a preview of what your tier structure will look like in a treeview control (in a similar fashion to the Nightwatchman Management console), before you commit the changes to the database.

Once i am happy with this structure I then want to be able to update these changes to the database using the stored procs or direct inserts into the Nightwatchman Staging table. When this is complete (and no error warnings have been given), it will then create the structure in the database and move the machines from the staging table into the correct tier location.

So far I have created an app which will read the csv file, create the datagridview and allow the preview of the treeview (minor tweaks needed for some UI improvements). If you would like to help or contribute to this project then please get in contact, I am pretty sure that more Nightwatchman users would find a tool like this useful.