Post reply

CMS

  • November 27, 2020 at 5:50 pm

    #3814513

    I am running a bunch of queries on the Central mangement server across 100's of servers.

    Is it possible to automate SQL queries against CMS ? Like using a SQL job etc..

    If yes can anyone please suggest.

  • November 28, 2020 at 6:10 pm

    #3814736

    Thanks for posting your issue and hopefully someone will answer soon.

    This is an automated bump to increase visibility of your question.

  • November 29, 2020 at 2:50 pm

    #3814888

    Thank you

  • November 30, 2020 at 8:13 am

    #3815048

    Probably need a bit more information like where the outputs are stored, but you could look at multi server jobs or things like powershell and the dbatools module and get it to pull the servers in from the CMS and run the queries you want it to

  • December 11, 2020 at 2:04 pm

    #3819396

    I would like to save the output on the CMS server itself.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply