October 23, 2015 at 8:42 am
I know how to get the last run date on all the databases on one server
i have a lot of servers and i was wanting a way of getting the last run date across all servers.
obviously it is in a table somewhere
October 23, 2015 at 8:53 am
Use a central management server or register all your servers in SSMS and run a query against the registered server group
October 23, 2015 at 12:09 pm
i thought about that but I need to write to a table and the linked servers are only one way direction
what i was hoping for is servera.dbbc
what i have is
servera linked to servers 1 to 200 so that gives me access for everything but dbcc
I understand how to run the query create an email using cms but how can i write to servera when it isnt linked that way
October 28, 2015 at 2:57 am
Recently did this using a Powershell script. There's loads of examples in google how to iterate through all your servers / databases to query the attributes you want.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply