[dba-VB] Unusual VB Request

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
> 
>