Endpoint Protection

I found this great article: https://www.symantec.com/connect/articles/compilation-sql-queries-sepm-database on SQL queries. I need a SQL query that exports all Windows 7 clients for the past year, the clients Computer name and serial number. This is what interchk has for pulling computer name and serial numbers: 

Select 
COMPUTER_NAME, BIOS_SERIALNUMBER 
from 
SEM_COMPUTER

Does anyone have an idea on how to update interchk's script to get the data I need?

That link probably the best place to also pose the question to some of those guys. You can also check out the DB schema:

Symantec Endpoint Protection 12.1.6 database schema

Thats all you need.

Select 
COMPUTER_NAME, BIOS_SERIALNUMBER ,Operation_system as Operating System
from 
SEM_COMPUTER