Skip navigation
769 Views 8 Replies Latest reply: Mar 11, 2014 11:27 AM by thho RSS
Rookie 8 posts since
Mar 28, 2012

Has received 1 of 9 achievements.
Currently Being Moderated

Mar 29, 2012 2:42 AM

Last application launches, last usage?

Hi all,

 

I'm trying to generate a report where it'll show me these attributes (for Microsoft Visio):

- Last launch date      (Software -> Package -> Last Started)

- Last duration           (Software -> Package -> Last Duration)

- Total launches        (Software -> Package -> Times Run)

- Total usage             (Software -> Package -> Duration)

 

* i tried getting the data from query as shown in the brackets, but it doesnt work well (same computer having like 200+ entries)

 

May I know which query should I go for to get these values?

also, is it possible to generate reports like daily or monthly usage of a specific software (MS Visio, MS Excel for example -- total launches and duration)?

 

 

Thanks,

Jo.

 

 

 

EDIT: added screenshot of what query I used and the Machine Components I choose.. & pic 002 is the result of duplicate entries

 

Thanks,

Jo.

Attachments:
  • simon.ma Employee 37 posts since
    Oct 6, 2009

    Has received 2 of 9 achievements.
    Currently Being Moderated
    1. Apr 12, 2012 10:44 AM (in response to jophua)
    Re: Last application launches, last usage?

    Hello Jo,

     

    I look at your Screenshot (001.jpg) and your issue came from your query.

     

    Your query look in "Software"."Add Or Remove Program"."Program"."Name", but for the column result, you are looking in "Software"."Package"."..."

    In this case, your query means that for any computer which have MS Visio in Add Or Remove Program, you want to report any usage for every products on these computers...

    That explain why your get more than 200 entries by computer...

     

    The query should use the Package field : "Software"."Package".Name" = "Microsoft Office Visio" for instance.

     

     

    Today, we don't have any usage data on daily or monthly basic....

  • simon.ma Employee 37 posts since
    Oct 6, 2009

    Has received 2 of 9 achievements.
    Currently Being Moderated
    3. Apr 13, 2012 3:43 AM (in response to jophua)
    Re: Last application launches, last usage?

    Jo,

     

    To avoid to have 200+ entries, you need to choose only fields on Package section (keep the same section of the query)

     

    So if you want to know which version of Visio is it, you can just add the version of the package... (Computer . Software . Package . Version).

    If the version is :

    •      11.x.xxxx : it is a 2003
    •      12.x.xxxx : it is a 2007
    •      14.x.xxxx : it is a 2010

    For the name of tha package, you can choose Computer . Software . Package . Name

     

     

    Concerning the usage on monthly basic, I'm not sure how you plan to do it, but the 2 options I can see right now are:

    • Log / Audit the fields :
        • Computer . Software . Package . Total Duration
        • Computer . Software . Package . Last Sarted

    and sum the total time using based on date (between 1st May and 1st April)

     

    • Reset every month, the usage data (functionnality available in SLM console).

     

    Simon

  • thho Rookie 3 posts since
    Dec 17, 2013

    Has received 1 of 9 achievements.
    Currently Being Moderated
    6. Mar 10, 2014 3:24 PM (in response to jophua)
    Re: Last application launches, last usage?

    Hello, I'm trying to run a similar queries on Landesk Management v.9.0

     

    I want to get a query export showing the sum of one workstation total last start within a 2 weeks time frame in one line.

    Instead of getting 200+ lines entries of the same workstation.

    I been messing with this all day, couldn't figure out a way.

    Our infrastructure has about 380 PCs that has the application.

    The cvs export report shows the total of 23983 entries of bunch of duplications.

     

    queries1.PNG

    queries2.PNG

    Please help!!! I need a resolution asap...

     

    Thanks...

  • simon.ma Employee 37 posts since
    Oct 6, 2009

    Has received 2 of 9 achievements.
    Currently Being Moderated
    7. Mar 11, 2014 7:36 AM (in response to thho)
    Re: Last application launches, last usage?

    Hello thho,

     

    Your current query is set up to show you all the "Last Time date" and "Time Run" for every packages on computers  having STAR Navigator 17 and Windows XP Pro.... that's why you have so many output lines.

     

    If you want to get the "Last Time Date" and "Time Run" only for STAR Navigator 17, you need to specify which package to look for.

    In the quey window, in the "Select Columns" section, you need to setup a qualifier for the "Last Time Date" and "Time Run", where you specify which package to look for.

    Sans titre.png

     

    Regards,

    Simon

  • thho Rookie 3 posts since
    Dec 17, 2013

    Has received 1 of 9 achievements.
    Currently Being Moderated
    8. Mar 11, 2014 11:27 AM (in response to simon.ma)
    Re: Last application launches, last usage?

    Thank you, you save my day!

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 20 points
  • Helpful Answers - 10 points
LANDESK Community powered by Jive SBS® 4.5.7.1  |  Legal Notices  |  Privacy Policy  |  Icon 

TweeterOn Twitter  |  Icon FacebookOn Facebook © 2007 LANDESK Software