Run the batch below file from desktop on your PIsys system. This will create a text file on desktop with name “versioninfo.txt”.

osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v4_0 from casmartcard where scmodel like '4%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v2_0 from casmartcard where scmodel like '2%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v5_0 from casmartcard where scmodel like '50%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v5_3 from casmartcard where scmodel like '53%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v5_4 from casmartcard where scmodel like '54%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v5_7 from casmartcard where scmodel like '57%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt
osql -Umcas -Pmcas -dMCASDB -Q"select count(*) AS v5_8 from casmartcard where scmodel like '58%%' and scuniqueaddress in (select scuniqueaddress from casmartcardgroup)" >> versioninfo.txt


after execution of above batch file  it will show like this

v4_0        
 ----------- 
           0 
 
(1 row affected)
 v2_0        
 ----------- 
           0 
 
(1 row affected)
 v5_0        
 ----------- 
       27875 
 
(1 row affected)
 v5_3        
 ----------- 
       13065