Hi Champs,
I have below query that gives me data of SW metering as per my needs. Looking
for help to accomplish two changes to it...
1) Display lastusage time of oldest per user/app, meaning when user used
application laaaast time, excluding all recent ones. Once after achieving this,
2) Second need is, add one more column that display result based on a case
statement if
a. Lastusagetime is GE 60 days then InactiveUse
b. Lastusagetime is LE 60 days but Usagetime is LE 30 mins then
InactiveUse else ActiveUsage
Current Query:
select MUR.fullname 'User', sys.name0 'Computer', SUD.productname,
SUD.filedescription, sud.filename, MUS.lastusage, mus.usagetime
from v_MonthlyUsageSummary MUS
join v_MeteredUser MUR on MUR.metereduserid=MUS.metereduserid
join v_r_system sys on sys.resourceid=MUS.resourceid
join v_GS_SoftwareUsageData SUD on SUD.FileID=MUS.FileID
where MUR.fullname in ('corp\vmiriyal')
Result of current/above query:
[cid:[email protected]]
This message contains information that may be privileged or confidential and is
the property of the Capgemini Group. It is intended only for the person to whom
it is addressed. If you are not the intended recipient, you are not authorized
to read, print, retain, copy, disseminate, distribute, or use this message or
any part thereof. If you receive this message in error, please notify the
sender immediately and delete all copies of this message.
