{"id":50,"date":"2015-08-28T11:25:15","date_gmt":"2015-08-28T08:25:15","guid":{"rendered":"https:\/\/amsd.go.ro\/wordpress\/?p=50"},"modified":"2021-09-07T11:26:21","modified_gmt":"2021-09-07T08:26:21","slug":"how-to-create-a-license-usage-report","status":"publish","type":"post","link":"https:\/\/amsd.go.ro\/wordpress\/?p=50","title":{"rendered":"How to create a License Usage report"},"content":{"rendered":"<div class=\"level1\">\n<p>In order to create a <strong>License Usage<\/strong> report you have to activate license tracking in Server information.<\/p>\n<p>The report will be generated afterwords exporting data from the query output (designed of Oracle database):<\/p>\n<p><span style=\"font-family: courier new,courier;\">SELECT a.USER_NAME, b.FIRST_NAME, b.LAST_NAME, a.APPLICATION, a.TYPE_OF_LICENSE, a.LAST_DATETIME FROM (SELECT USER_NAME, APPLICATION, TYPE_OF_LICENSE, TO_CHAR(TO_DATE(&#8217;01\/01\/1970 00:00:00&#8242;, &#8216;MM\/DD\/YYYY HH24:MI:SS&#8217;) + (MAX(TIME) \/ ( 60 * 60 * 24 )), &#8216;MM\/DD\/YY HH24:MI:SS&#8217;) as &#8220;LAST_DATETIME&#8221; FROM AR_SYSTEM_HISTORICAL_LICENSE_U WHERE APPLICATION = &#8216;BMC:Incident Mgmt&#8217; OR APPLICATION = &#8216;AR Server&#8217; GROUP BY USER_NAME, APPLICATION, TYPE_OF_LICENSE ORDER BY USER_NAME) a INNER JOIN CTM_PEOPLE b on a.USER_NAME = b.REMEDY_LOGIN_ID;<\/span><\/div>\n","protected":false},"excerpt":{"rendered":"<p>In order to create a License Usage report you have to activate license tracking in Server information. The report will be generated afterwords exporting data from the query output (designed of Oracle database): SELECT a.USER_NAME, b.FIRST_NAME, b.LAST_NAME, a.APPLICATION, a.TYPE_OF_LICENSE, a.LAST_DATETIME [&hellip;]<\/p>\n<div class=\"link-more\"><a href=\"https:\/\/amsd.go.ro\/wordpress\/?p=50#more-50\" class=\"more-link\">Continue reading &#10142; <span class=\"screen-reader-text\">How to create a License Usage report<\/span><\/a><\/div>","protected":false},"author":6,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[13,14,17,10,18,12],"class_list":["post-50","post","type-post","status-publish","format-standard","hentry","category-technology","tag-ps_40","tag-ps_41","tag-ps_33","tag-ps_32","tag-ps_39","tag-ps_17"],"_links":{"self":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/50","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=50"}],"version-history":[{"count":1,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions"}],"predecessor-version":[{"id":191,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=\/wp\/v2\/posts\/50\/revisions\/191"}],"wp:attachment":[{"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=50"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=50"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/amsd.go.ro\/wordpress\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=50"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}