Re: Difference in SW Inventory Reports

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Hector and Garth!

This issue is documented in the Reporting Frequently Asked Questions at:
http://www.microsoft.com/technet/prodtechnol/sms/sms2003/techfaq/tfaq10.mspx

Q. There seems to be a limitation on the Web Reporting tool of 10,000
records. Is there any way to increase that? (Updated May 31, 2006)
A. You can change the limit by modifying the registry on the reporting
point machine. Under the HKEY_LOCAL_MACHINE\Software\Microsoft\SMS\Reporting
key, add the DWORD value Rowcount and assign it the value for your desired
maximum limit. The maximum row count in decimal is 32767. If you need to
return more than 32,767 records, you can set the row count to 0xffffffff
hexadecimal, which will return all rows. However, this significantly
increases the workload on the SMS site database. If you experience problems
displaying the values in reports, add the Values Rowcount registry key by
using the same settings as above.

Be aware that if you increase this value, you might also need to
adjust the AspBufferingLimit setting. For more information about changing
the AspBufferingLimit setting, see the FAQ "When my Web reports contain a
column that has more than 5,000 records I get an IIS error 500 on my IIS 6.0
reporting point. How do I fix this?" earlier in this document.



Hope this helped!

Jeff Gilbert, MCSE
Technical Writer | Windows & Enterprise Management Division
Microsoft Corporation

This posting is provided "AS IS" with no warranties and confers no rights.

"Garth" <Spam@xxxxxxx> wrote in message
news:OFMRWI2qGHA.5108@xxxxxxxxxxxxxxxxxxxxxxx
using the web reports you can export the result to a csv file. Because of
the number of records you are talking about you will need to modify the
default number of records returned by default. I don't have the reg key
handy but I will look it up and get back to you.


"HectorOcando" <HectorOcando@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EF5CE595-185A-4D83-8A52-1047FF104DEC@xxxxxxxxxxxxxxxx
Thanks for the information Garth!
And you right, the 'Add/Remove Program.DisplayName' information is not
the
same as 'SoftwareProduct.ProductName'.

Anyone knows, how to make a automatic export list to a text file, from a
SW
inventory query?
We will expect to have 10.000 clients and almost 150 sofwtare
entries/each
one.
_____________________________________________________
"Garth" wrote:

v_GS_ = Current Information
v_HS_ = Historical Information

yes you can nest queries.

From my quick look no you can't get he A/R info from ProdcutName


"HectorOcando" <HectorOcando@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C45B043A-B83D-4E3E-9EED-F060C1651D50@xxxxxxxxxxxxxxxx
When I made a report, which is the difference between a "v_XXXX",
"v_GS_XXXX", and "v_HS_XXXX" view, for example: v_SoftwareProduct,
v_GS_SoftwareProduct, v_HS_SoftwareProduct?

Can I nest queryies? can i get per machine the
SoftwareProduct.ProductName,
and use this value to get the v_GS_ADD_REMOVE_PROGRAMS.DisplayName0?

Thanks......

______________________________________________________-
"HectorOcando" wrote:
I'm sorry, but I know very little about writing query statements and
I
need
to create a report with de SW installed correctly in ours machines,
file
and
registry.

Actually, we configured our SW inventory process to collect
everything
under
%programfiles%. But, when we make the query using "Count of all
instantes
of
software registered with Add or Remove Programs", we found that the
SW
appear
as installed, but sometimes it haven't the EXE file, or viceversa,
EXE
file
exist without entrances in the registry. We know, that field
operations
must
have executed their processes badly, and we must make a massive
cleaning
of
registries.

Nevertheless, meanwhile, we want to know if it is possible to make a
query
that give us the information about which SW has their registry
entries
and
has their EXE file installed, show us the machine name, the user
account,
the
SW product name, and the product version. and later, to permit us
export
that
information to a text file. It is posible? to ambitious?

thanks in advance, and excuse the extensive thing...








.

Relevant Pages

  • Re: Difference in SW Inventory Reports
    ... Thanks Jeff, I have been running around with my head cut off this week and I ... This issue is documented in the Reporting Frequently Asked Questions at: ... You can change the limit by modifying the registry on the ... as installed, but sometimes it haven't the EXE file, or viceversa, ...
    (microsoft.public.sms.inventory)
  • Re: dumprep?
    ... disable the registry entry. ... But keep in mind that dumprep is not the ... instead it is the good program that is reporting a serious ... "Marek Kalisz" wrote: ...
    (microsoft.public.windowsxp.help_and_support)
  • Re: RegWrite fails on Vista?
    ... this worked, however in Vista, running as elevated command prompt, it is ... reporting an error. ... and I'm not familiar with the registry key you're trying to write. ...
    (microsoft.public.scripting.wsh)
  • Re: Cant get onto computer - please help!
    ... To launch the registry editor, ... When reporting back, don't just say "I couldn't do this or that". ... > command prompt, but there was never a time when I could type in anything, ... > How do I change the registry? ...
    (microsoft.public.win2000.general)
  • RE: SMS reports
    ... To access the Web Reporting site you either have to be ... administrator or a member of the SMS Reporting Users ... it does not give the user security ...
    (microsoft.public.sms.admin)