SQL Help For Report

Does anyone have a sql report that encompasses scan history… So lets say i have site 1 site 2 and site 3; scans take place weekly. I want all the scans for the month april and june that have taken place so far… is that possible for each site or all sites with authentication?