New resource proposal: Server and database audit

[imarambiocatan]

I've been trying to use this module alongside with DSCEA to check for compliance which means I have an SQL server environment already and have run into some issues
the first is that right now the SQLserverlogin resource requires a the name of the user to check for compliance with the various password policy options. I solved this using a lot of imagination and connecting to the various SQL server instances to generate several mof files, one per computer. This one won't be fixed in all likelyhood
the second is that I have yet to find how to configure the database audit policy with DSC. is this even possible?

[johlju]

@imarambiocatan Is it SQL Server Audit (Database Engine) you are looking if there are support for? If so, there are no resource that handles this yet. It would be possible to add a resource for this when looking at Creating and Managing Audits with Transact-SQL.

[imarambiocatan]

Yes, that is correct, that is what I'm looking for. Is there another way to do this? within dsc i mean

[johlju]

There are no DSC resource for this, so currently no. I labeled it help wanted so that anyone in the community can run with it.

[Fiander]

Hi,
just started with this for myself and just found this issue.
I have the audit ( the storage part ) running.

I am now starting with the serverAuditSpecifications part. the databaseAuditSpecifications part wil be last.
https://github.com/Fiander/SqlServerDsc

[johlju]

Cool! Happy to review a PR if you want to send it in here.