I would like get reports in CVS. Format which was exported from Qualys in to MS SQL Server.
This process I would like do automatically, because I setup a lot scans and on the end I am getting lot of reports.
I get Idea set up: SQL Server Integration Services which will take every time cvs. file automatically in to SQL Server.
Problem can be with authentication. (I can set up In Qualys: thing which will send me Encrypted PDF file on my email but I do not know how I can download automatically PDF/CVS/txt from my email + unzip/open + Transfer to SQL server.
(For downloads from email Iam useing Wget+ task scheduler )
My target is make scripts/Selects/Triggers in SQL to pick up interesting things and send them to Admins.
Thanks for any opinions.
(I read https://community.qualys.com/message/18946?commentID=18946%23comment-18946 but is 4 years old