Skip to Content
0

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

Jan 04, 2017 at 05:56 AM

93

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Manikandan Elumalai Jan 04, 2017 at 08:13 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11, 2017 at 12:23 PM
0

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!

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11, 2017 at 12:29 PM
0

refer the error screenshot


error.png (12.0 kB)
Show 1 Share
10 |10000 characters needed characters left 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

0
avatar image
Former Member Jan 11, 2017 at 01:15 PM
0

Run this macro where you have installed client Tool

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11, 2017 at 04:13 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

This may be basic checks. But did you tried with Server IP, Server FQDN etc.. Were you able to ping the server from the machine from where you are launching teh utility?

Thanks

Mani

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 11, 2017 at 05:40 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Check this https://blogs.sap.com/2013/09/13/businessobjects-administration-relationship-queries/

But I dont think you can export the resultset to Excel or so.

Thanks

Mani

0