Got a request by my manager to see if I can generate a report that tells me what role is installed on each server. He's looking for a bit of detail such as Exchange version, SQL version etc which doesn't come up when I map the v_xr_computerrolescategories data source. That data source gives me a very basic rundown of what role is installed on the server without any versions or details.
I contacted support and they showed me the Computer Role Detection dataview which gives me a bit more info but still doesn't show the Exchange version or SQL version
Just wondering if anyone knows of a way to grab that from Automate and put it into a report? Or if it's even possible. An alternative I was thinking we could do is run some scripts that grab that info from the server and stick it in a EDF then report on that but my manager wants to try to stay away from scripts so that we don't have to update them each time a software version is released.