Kaseya Community

SQL Query

  • Hi,

    I am looking to be able to have Kaseya query a database that's local to the client server, and then return the results back to my Kaseya server.

    eg - say I have the agent installed on a box running sql, and that box has a database on it that is called "database1". I want to be able to query database1 and return the results back to my server for further analysis on a regular basis

    Anyone got any ideas on how I could achieve this using a script?

    Legacy Forum Name: SQL Query,
    Legacy Posted By Username: smcleod
  • Least hassle would probably be using the sqlcmd utility.

    Nice quick tutorial here http://technet.microsoft.com/en-us/library/ms170207.aspx

    Legacy Forum Name: Script Requests,
    Legacy Posted By Username: CNelsonT2