Skip to Content
avatar image
Former Member

Report on Users who have not logged in BOfor consecutive 30 & 90 days

Hi,

I need to find users who have not logged in BO for consecutive 30 & 90 days. Useing Query Builder I ran the query .

SELECT TOP 5000 SI_NAME, SI_LASTLOGONTIME FROM CI_SYSTEMOBJECTS WHERE SI_NAME NOT IN ('ADMINISTRATOR','GUEST') AND SI_KIND='USER' AND SI_LASTLOGONTIME > '2015.09.04' ORDER BY SI_NAME

Is there any way to verify the output.

And how to import the result into excel.

How to access Infostore Query

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Jan 04, 2017 at 08:13 PM

    Use this utility and cross verify your QB output with the utility's output.

    http://www.forumtopics.com/busobj/viewtopic.php?t=204084

    Thanks

    Mani

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 12:23 PM

    Hi,

    I downloaded the utility. But it throws an error saying Server name is not correct.

    And i am using the correct ip address of the server on whoch we have CMC.

    BO version is 4.1 SP 3

    Any comments!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 12:29 PM

    refer the error screenshot

    Add comment
    10|10000 characters needed characters exceeded

    • try to connect any of the client tools (UDT, IDT or WRC) from the machine where you are running the utility. As long as it works with your client tools it should work for this utility.

      Hope you installed client installer in the machine as well.

      Thanks

      Mani

  • Jan 11, 2017 at 01:15 PM

    Run this macro where you have installed client Tool

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 04:13 PM

    yes i am running this macro on the jump server where client tools are installed like UDT,IDT.. still no success

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 05:40 PM

    Yes instead of writing the host name i wrote the Ip address itself. And yes i am able to ping the server from where i am launching the utility.

    Also there ia way to export info from CMC using Query Results. How and from where to export the results .is it feasible in bo 4.1

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 11, 2017 at 05:40 PM

    Yes instead of writing the host name i wrote the Ip address itself. And yes i am able to ping the server from where i am launching the utility.

    Also there a way to export info from CMC using Query Results. How and from where to export the results .is it feasible in bo 4.1

    Add comment
    10|10000 characters needed characters exceeded