How to Perform a Basic Software Audit (Query)

Quick follow up to How to Perform a Basic Software Audit

Do you want to know how many ARP entries you have?

How many page of paper you will get if you print all of the entries?

What about bundles of paper?

 

Use this query to help you determine this for you.

 

declare @ARP BIGINT
Set @ARP = (select count(*) from dbo.v_Add_Remove_Programs)

Select
‘Number of ARP entries ‘ + convert(varchar(10), @arp),
‘Number of pages ‘+ convert(varchar(10), sum(Round(@arp/80,0)+1)),
‘Number of papper Bundles ‘+ convert(varchar(10), round(sum(@arp/40000.0),2))

Leave a Reply

Your email address will not be published. Required fields are marked *