Re: Software Inventory - Microsoft License True Up - SQL Version and P



I just went through attachung to each sql server with query analyzer and
running

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'),
SERVERPROPERTY ('edition')See
http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185


"Brian C. from Boulder" <BrianCfromBoulder@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote
in message news:A212BC23-8AD8-4553-8A78-6BC5CDD2A3DB@xxxxxxxxxxxxxxxx
Greetings,

I'm in need of help to determine how best to pull inventory information
for
the Microsoft True Up, in particular reference to MS SQL.

Using any means available, Add/Remove Programs, file name = sqlservr.exe,
etc. do not display the needed "Enterprise" or "Standard" labeling that is
needed for the MS True Up. In addition using the file name "sqlservr.exe",
I'm unable to determine the difference between MSDE and SQL.

Has anybody had success in determining inventory information for MS SQL
for
Microsoft True Up? If so, what would be some of your suggestions?

On a similar note. MS Project does not report Standard or Professional.
Has
anybody been successful in determining what version of Project is being
inventoried?

Thank you very much!

Sincerely,
Brian



.



Relevant Pages

  • Re: SQL Serverlicense compliance
    ... Have you tried doing a "select serverproperty " in SQL? ... or extend WMI and get this over to Hardware Inventory. ... "Henrik " wrote in message ...
    (microsoft.public.sms.inventory)
  • Re: Changing server collation
    ... The serverproperty shows the collation as ... Sql_ Latin1_General. ... What does the SERVERPROPERTY() function say? ... When I look at rebuildM now, it shows Dictionary Order, Case ...
    (microsoft.public.sqlserver.server)
  • Re: SQL License
    ... Check out SERVERPROPERTY() in BOL. ... Andrew J. Kelly SQL MVP ... > Is there a Query to find the licesnse scheme that SQl is using? ... procesor or per seat and does it give a quantity? ...
    (microsoft.public.sqlserver.programming)
  • Re: Software Inventory - Microsoft License True Up - SQL Version a
    ... I would like to leverage this tool within SMS. ... checked sql versions in the sms.swdist group. ... Has anybody had success in determining inventory information for MS SQL ... MS Project does not report Standard or Professional. ...
    (microsoft.public.sms.admin)

Loading