Creating report about ethernet cards

[askinerdem]

Hello,

I have a question. In our domain there are some users who have more than 1 ethernet card. Our domain is secure and we do not want users to connect internet without our proxy servers. To prevent this we need to find the computers which have 2 or more ethernet cards. How can I creat such a report query? In my report I want to see results like this:

pc001 2 ethernet cards
pc002 3 ethernet cards
.......................

 

[ncotton]

If you have any SQL experience, you could create your own report. I dont have access to any SMS DB's and haven't touched if for a couple of years so I cant remember the fields/table names etc.

But explorer your SMS database and find the data that you want to report on and create a report with

SELECT SystemID, (count)NIC
FROM tablename
WHERE
(count)NIC>1;

Neil J Cotton
Technical Consultant
Anix