Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 3 replies
  • Subscribers 1 subscriber
  • Views 4381 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

SQL Query Request

MGuido

Would anyone have a SQL query that would be able to extract the data for laptops in the database?  I would like to know:

Domain Name

Computer name

IP Address

Last Username (if avail)

Version SAV

Number IDE

Primary CID

Secondary CID

Group

I don't know if the database determines machine types at all.  Typically we place laptops into our AD in their own OU and non-AD laptops get thrown into a group called Laptops

Many thanks

M

:38083


This thread was automatically locked due to age.
Parents
  • 0

    HI,

    Maybe this post will help you:

    /search?q= 28885

    Sophos Reporting Interface asside, the view you want to use is ComputerListData2, that has all the values you need.  You just need to join on the 

    GroupPathAndNameTable()

    Function to get the full group path name from the GroupID.

    Note: you can also perform ctrl-C, Ctrl-V on the computer list view in SEC and paste into Excel if that's good enough for a basic report.

    Regards,

    Jak

    :38085
Reply
  • 0

    HI,

    Maybe this post will help you:

    /search?q= 28885

    Sophos Reporting Interface asside, the view you want to use is ComputerListData2, that has all the values you need.  You just need to join on the 

    GroupPathAndNameTable()

    Function to get the full group path name from the GroupID.

    Note: you can also perform ctrl-C, Ctrl-V on the computer list view in SEC and paste into Excel if that's good enough for a basic report.

    Regards,

    Jak

    :38085
Children
No Data