I am trying to put together a SQL Query to pull the data from the DB to include the following data
I have looked for the relationship between the computer group and the computer. I would like to pull a report that shows the computers assigned to a particular computer group. Additionally I would like to tie those two items with the relevent fixlets for each computer. Any help would be appriciated.
That’s a good start, but that could be a LOT of data.
2 questions:
How are you going to view this data? Just in a query window, or do you have a report interface?
Can you narrow the scope of fixlets that you want results from? Like only certain fixlets, or only fixlets from one site?
Basically, with the right query, you’ll get a row for each computer that is relevant per fixlet.
In other words, if you have 10,000 computers and they are all relevant to 100 fixlets each, then that’s 1,000,000 rows you are returning from the database. I know my BES box can handle that… but is that the type of output you are looking for?