microsoft / Microsoft365DSC

Manages, configures, extracts and monitors Microsoft 365 tenant configurations
https://aka.ms/M365DSC
MIT License
1.59k stars 501 forks source link

customer reporting #4980

Open Kimhal opened 2 months ago

Kimhal commented 2 months ago

Hi We are already using the reports (configuration and delta, in the html and excel format) built in the DSC engine, but we are finding us self in need for different visualization tools, that we can use for our customers. This can Excel, PowerBi or another application. My question is. Are there another way to visualize the extracted data for the customer?

In advance thank you.

FabienTschanz commented 2 months ago

@Kimhal Aside of HTML and Excel exports, there is only the JSON type left, from which you could build your own data reporting visualization. Microsoft365DSC doesn't provide anything more than that, so you would need to script or build it yourself.

StevenTx742 commented 2 months ago

Is anyone doing that? Building reports from JSON?

FabienTschanz commented 2 months ago

Honestly, no idea. But if the HTML and Excel reports aren't the ones you are looking for, you gotta build it yourself 😅

andikrueger commented 2 months ago

Im really interested in what kind of reporting you plan to build. What are your objectives for the new reporting capabilities?

At the moment there are the JSON, HTML and excel option implemented. With JSON being the most versatile option for further data processing.

dbrinkmann123 commented 2 months ago

fwiw - We'd prefer to store the exports in JSON and then do our own reporting. We aren't looking to use dsc to import changes, just track changes across multiple tenants daily. if only the export exported json natively vs only in the parser.