[dba-VB] Unusual VB Request

Turns out that Maximo can run on DB2, Oracle or SQL Server.  So if you can find out what 
platform it is running on, have appropriate login rights  and you have access to appropriate 
ODBC drivers you may be able to do it.  

And to answer Gustav's point, if that is so, then you could write a PowerBasic native code 
DLL fairly easily to do it :-)

-- 
Stuart


On 20 Feb 2011 at 22:07, Stuart McLachlan wrote:

> I'd say you are SOOL.  
> 
> Initially it didn't make sense needing a IP address *and* Hostname  to
> get an OS Username so I did a bit of googling.
> 
> The key was .psdi
> 
> It appears that psdi classes are implementations of an Interface to
> the IBM's (originally PSDI's) java based Maximo Asset Management
> System.   
> 
> I'd guess that the function is looking at the Maximo database which is
> running on Hostname to find out if someone is logged into it from the
> workstation at IP address and returniing the username if there is
> someone logged in.
> 
> Without knowing a lot more about the internals of Maximo, there is no
> way to come up with an independent way of getting this information
> 
> It is the same as asking who if anyone on workstation xxx.xxx.xxx.xxx
> is logged into an SQL Server instance.   You need to know how that
> information is stored inside the the RDBMS, how to gain access to that
> data and how to extract it.
> 
> -- 
> Stuart
> 
> On 19 Feb 2011 at 11:06, Michael Maddison wrote:
> 
> > Hi Guys,
> > 
> > 
> > 
> > Maybe someone can confirm or negate my thoughts on a client request
> > I have received?
> > 
> > 
> > 
> > Consider this code...
> > 
> > import psdi.util.AXWin32Util;
> > 
> > 
> > 
> > Call to DLL:
> > 
> > 
> > 
> >         if (this.debug) {
> > 
> >           System.out.println("Checking for user at ip " + address +
> >           " on
> > " + host);
> > 
> >         }
> > 
> >         OSUsername = AXWin32Util.getOSUserName(address,
> >         host).trim();
> > 
> > 
> > 
> > 
> > Username is one value not delimeted list
> > 
> > 
> > 
> > 
> >         if ((OSUsername != null) && (OSUsername.length() > 0)) {
> > 
> >           if (this.debug) {
> > 
> >             System.out.println("Found user " + OSUsername + " on " +
> > host);
> > 
> >           }
> > 
> >           OSUsername = OSUsername.toUpperCase();
> > 
> > 
> > 
> > I think the above is Java?
> > 
> > 
> > 
> > My client wants me to write a dll to replace the
> > AXWin32Util.getOSUserName(address, host) method call.
> > 
> > 
> > 
> > I don't have access to either the original source (dll) or the
> > source to the calling app. Just the text above.
> > 
> > If I create a COM dll called psdi.util.AXWin32Util.dll with a
> > getOSUserName method and register it on the target server what are
> > the chances it will work?
> > 
> > I suspect the answer is zero.
> > 
> > 
> > 
> > Dotnet is not allowed. No installation is allowed. The server is Win
> > 2003 sp2. 
> > 
> > 
> > 
> > Ideas anyone?
> > 
> > 
> > 
> > Cheers
> > 
> > 
> > 
> > Michael
> > 
> > _______________________________________________
> > dba-VB mailing list
> > dba-VB at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/dba-vb
> > http://www.databaseadvisors.com
> > 
> > 
> 
> 
> 
> _______________________________________________
> dba-VB mailing list
> dba-VB at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-vb
> http://www.databaseadvisors.com
> 
>