My project requires up to date information on the currently live File Repository Server. I know this information can be found by manually entering a SQL statement into the Query Builder Tool. However, I have been asked to create a script that performs this task automatically and repeatedly. When the details of the FRS change, the up to date information must be logged to the Windows Event log from which the information will be lifted by our company's internal log monitoring tool.
If anyone can give me an idea of how I might do this I would certainly appreciate the help. I would also be thankful for any suggestions for alternative solutions to the one outlined above. For instance is there a given pattern I can search any of the BOE log files for to gather the required info?
I'm a total newbie, so apologies if any of the above sounds a bit naiave or just down right stupid...