cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member336382
Participant
0 Kudos

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

Accepted Solutions (0)

Answers (7)

Answers (7)

former_member336382
Participant
0 Kudos

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

former_member182521
Active Contributor
0 Kudos

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

former_member336382
Participant
0 Kudos

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

former_member336382
Participant
0 Kudos

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

former_member182521
Active Contributor
0 Kudos

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

former_member205064
Active Contributor
0 Kudos

Run this macro where you have installed client Tool

former_member336382
Participant
0 Kudos

refer the error screenshot

former_member182521
Active Contributor
0 Kudos

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

former_member336382
Participant
0 Kudos

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!

former_member182521
Active Contributor
0 Kudos

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