Database / Reports Question - Is this possible?

(imported topic written by tscott91)

We have a department that does fraud investigation… I get emailed 2-3 times a day where they give me an IP address and ask who is logged into the PC and where it’s at…

All I do is go into the BigFix console, type in the address, and I instantly see the logged on user and I created a property for location by subnet… I email her those two fields and that’s that…

It literally takes me seconds but it’s annoying to do this every single day… I don’t want to give her access to Web Reports as this would give her too much information…

I don’t know how I could accomplish it so she can access this info herself but I was wondering if anyone knew what the table is that may have all this info? Then I can just write my own webpage where she just types in the IP address and it pulls the two values for her…

Ideas?

Thanks!

(imported comment written by bxk)

You can make your web app, call the web reports soap API to get the data using relevance.

(imported comment written by tscott91)

Thanks for the reply… That sounds good but I’m not familiar with SOAP… I use vb asp.

(imported comment written by SystemAdmin)

http://www.codeproject.com/KB/asp/SOAP___Classic_ASP.aspx