Need a query report for MySQL

Need a query report for MySQL

Hi,

Is it possible you could generate a query in Mysql format for me, so I can produce a report?

'Resource Name' and ' all scans of a workstation report within the last 30 days'.
 
Something like that:

      WK

Scan date

Status

Workstation1

01/06/2012

Successful

Workstation1

02/06/2012

Successful

Workstation1

03/06/2012

Failure

Workstation1

04/06/2012

Successful

Workstation1

05/06/2012

Successful

 
Thanks,
Maria
 
 

 

                  New to ADSelfService Plus?