Re: Unable to Create Collection/Query On Custom Created Data (WMI/MOF)

Tech-Archive recommends: Fix windows errors by optimizing your registry

Using an read only account that we use for SQL queries, I can see all
the data.

Mike

Steve Thompson wrote:
<sultanoswat@xxxxxxxxx> wrote in message
news:1151505787.752101.212070@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
We're trying to get some custom information into SMS. To do this we've
created a vbScript that collects the data & pulls it into the registry.
From there we created a .mof file that adds the data into WMI. From
there a HW Inventory brings the data into SMS.

Using SQL QA, I can see that the data has been pulled into SMS. It
created a VAT_DATA & VAT_HIST user table with columns like MachineID,
InstanceKey, etc. and columns that we've defined with two 00s after the
name (like Building00, Location00, and KeyName00). A view is also
created call v_GS_VAT0 with a ResourceID, and our column names with a
single 0 after the name (Building0, Location0, KeyName0). We're able to
create SMS reports on this view & up until that point all was well.

However now we'd like to create collections based on this data. When I
create a collection, it tells me that we don't have security rights to
perform this operation. When I attempt to make a query, I get a
WBEM_E_FAILED error.

Can anyone help/offer a solution?

Can you create an SMS query to present this data? If you cannot, check the
permissions on the base tables to be sure that these permissions are
consistent with the other SMS tables.

Steve

Steve

.

Relevant Pages