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)
‘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))