BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: BI & HANA 2018 Prague: Jun 29.

Powershell and BOXI


 
Search this topic... | Search General Discussion... | Search Box
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Author Message
Geo68
Forum Member
Forum Member



Joined: 12 Jun 2009

Posts: 12



PostPosted: Wed Jun 13, 2018 7:53 am 
Post subject: Powershell and BOXI

Hi

If I log into Query builder on one of the BOXI Servers and enter the query

SELECT SI_NAME,SI_DESCRIPTION,SI_USERFULLNAME,SI_USERGROUPS,
SI_CREATION_TIME,SI_LASTLOGONTIME
FROM CI_SYSTEMOBJECTS
WHERE SI_KIND='User'

I get information returned If I now put the same select statement into a Powershell script and run it I get different information. How do I change my select in the powershell script so it returns the same information as the select in Query builder.

Any help/pointers would be gratefully appreciated.

Geo68
Back to top
jemstar
Forum Associate
Forum Associate



Joined: 30 Mar 2006

Posts: 799
Location: Dublin , Ireland


flag
PostPosted: Wed Jun 13, 2018 8:10 am 
Post subject: Re: Powershell and BOXI

Query builder only returns 1000 records. I always add select top 100000 from
to my query builder SQL statements.

_________________
regards,

James

http://www.jemstar.ie/

Available for Contract Work In Ireland (and remote work worldwide)

Expert in Universe Creation directly over Enterprise applications (JDE, BMC Remedy, EBMS, Jira, ArisG, Bespoke, Mercator, RAPID, M3, Movex, Investpro)
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> General Discussion  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0109 seconds using 18 queries. (SQL 0.0030 Parse 0.0002 Other 0.0077)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo