1 Reply Latest reply on Aug 21, 2008 6:09 AM by MarXtar

    List licenses that were input into SLM

    Rookie

       

      Is there some way I can pull the License information that I enter into SLM so that I can show for example, the License numbers and quantities for Microsoft Office Professional Plus 2007?  I know it is in the DB somewhere, but I can seem to find it to build a custom report.   Anyone know?

       

       

       

       

       

      Thanks

       

       

      Ed

       

       

        • 1. Re: List licenses that were input into SLM
          MarXtar ITSMMVPGroup

           

          Try creating a view with this SQL script:

           

           

           

           

           

          SELECT     dbo.Product.Title AS Name, SUM(dbo.ProductLicense.Quantity) AS Quantity

          FROM         dbo.Product INNER JOIN

                                dbo.CustomGroupProduct ON dbo.Product.Product_Idn = dbo.CustomGroupProduct.Member_Idn INNER JOIN

                                dbo.ProductLicense ON dbo.CustomGroupProduct.CustomGroupProduct_Idn = dbo.ProductLicense.CustomGroupProduct_Idn

          GROUP BY dbo.Product.Title

           

           

           

           

           

          This should give one line per product and total the number of licenses that have been entered.

           

           

          Mark Star - http://www.marxtar.com

           

           

          Home of Power State Notifier & Wake-On-WAN for LANDesk