Problem with v_MeteredFiles view (Full Version)

All Forums >> [Management Products] >> Microsoft Systems Management Server >> SMS 2003



Message

mbaird -> Problem with v_MeteredFiles view (9/29/2008 5:43:46 PM)

I am using SMS 2003 SP3 and when I run a simple SQL query from the query analyzer I get back multiple rows when I think I should only get back one row.  The query is as follows:

Select * from v_MeteredFiles mf where mf.MeteredFileID = 8541704

I think there should only be one metered file id associated with each Metered product or rule.  However, the view returns six diferent products and rules for this one ID.  Can someone tell me if the metered file ID should be unique for each product or software metering rule?

Is so, how would I go about correcting the problem?



gjones -> RE: Problem with v_MeteredFiles view (9/30/2008 8:31:30 AM)

How is your rule written for this metered file?



mbaird -> RE: Problem with v_MeteredFiles view (9/30/2008 11:52:10 AM)

There are 6 different rules associated with the FileID so I am not certain which one originally created it.  However, I have noticed that the File Name or Original File Name of the six rules contain the phrase "Not applicable".  This phrase is also listed in the Metered Filename field.
RuleID ProductID               Original filename           Filename                                          FileID          ProdID      Metered Filename
3          Autocad LT              Not applicable.             aclt.exe                                              8541704   42720       Not applicable.
5          BearShare                Not applicable.             Bearshare Music free - BS242.exe     8541704   42720       Not applicable.
6          BitTorrent                 Not applicable.             btdownloadgui.exe                            8541704   42720       Not applicable.
9          Cain                         Not applicable.             Cain.exe                                            8541704   42720       Not applicable.
13        iMeshClient              imeshlight423a.exe       Not applicable.                                 8541704   42720       Not applicable.
31        Morpheus                 Not Applicable.            Morpheus-b3d-v2.exe                         8541704   42720       Not applicable.



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
0.515625