So I made a script that loops through servers and sets up DataSources and Data Collector Sets. The script works, but there is one issue, and I've lost hope.
The DataCollector Set runs per default as "SYSTEM", but that makes it impossible to start the Datacollector Set, because I need it to be a "USER" that has access to the SQL Server where the Performance Monitor is saving the collected data.
This is an example of what the idea is.:
Im setting up a ODBC DataSource and a DataCollector Set on Server 1, Server 2.... They save the Perfmon Data to a SQL Database in another, Monitoring Dedicated SQL Server.
I can change the "Run as" property in the Data Collector Set manually, but that is no one's goal. I need to be able to change it with Powershell.
I need to change this property, but with Powershell. And everything will work.
