Looking for a SQl query that can return the network IP address for all servers both netbios and FQDN

For example,

ServerA Network Interface IPAddress.

Also a sql query that can return the servername and KS's that are running on that server and what is their severity?

I integrate AM 9.1 to HP and using the netiq HP adapter forward over any critical events of severity 6 to our notification application.

So looking for any server and KS that meets this?