Jump to content


Search the Community

Showing results for tags 'Custom'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Cloud
    • Azure
    • Microsoft Intune
    • Office 365
  • General Stuff
    • General Chat
    • Events
    • Site News
    • Windows News
    • Suggestion box
    • Jobs
  • MDT, SMS, SCCM, Current Branch &Technical Preview
    • How do I ?
    • Microsoft Deployment Toolkit (MDT)
    • Official Forum Supporters
    • SMS 2003
    • Configuration Manager 2007
    • Configuration Manager 2012
    • System Center Configuration Manager (Current Branch)
    • Packaging
    • scripting
    • Endpoint Protection
  • Windows Client
    • how do I ?
    • Windows 10
    • Windows 8
    • Windows 7
    • Windows Vista
    • Windows XP
    • windows screenshots
  • Windows Server
    • Active Directory
    • Microsoft SQL Server
    • System Center Operations Manager
    • KMS
    • Windows Deployment Services
    • NAP
    • Failover Clustering
    • PKI
    • Windows Server 2008
    • Windows Server 2012
    • Windows Server 2016
    • Windows Server 2019
    • Hyper V
    • Exchange
    • IIS/apache/web server
    • System Center Data Protection Manager
    • System Center Service Manager
    • System Center App Controller
    • System Center Virtual Machine Manager
    • System Center Orchestrator
    • Lync
    • Application Virtualization
    • Sharepoint
    • WSUS

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


AIM


MSN


Website URL


ICQ


Yahoo


Jabber


Skype


Location


Interests

Found 3 results

  1. I have a working SQL query courtesy of Eswar Koneti (https://gallery.technet.microsoft.com/office/SCCM-Configmgr-2012-SSRS-c482cca2/). Due to being new to SQL/SSRS custom report building, I am struggling with trying to limit the scope of these results to a specific collection. What I would like to do is add a statement in the query to limit the results to a specific collection ID(s). I am not looking to make a drop down of collections in the report. Here is what I have so far: SELECT COUNT (Total.Name0) AS 'Total Clients', COUNT (office2003.Name0) AS 'Office 2003', COUNT (Office2007.Name0) AS 'Office 2007' , COUNT (Office2010.Name0) AS 'Office 2010', COUNT (Office2013.Name0) AS 'Office 2013', COUNT (Office2016.Name0) AS 'Office 2016' FROM ( SELECT vr.Name0 FROM v_R_System vr WHERE vr.Client0=1 AND vr.Operating_System_Name_and0 NOT LIKE '%server%') AS Total LEFT JOIN ( SELECT DISTINCT sys.Name0 , displayname00 AS OfficeEdition , version00 AS OfficeVersion FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey = arp.machineid WHERE(displayname00 ='Microsoft Office Basic Edition 2003' OR displayname00 ='Microsoft Office Excel 2003' OR displayname00 ='Microsoft Office Outlook 2003' OR displayname00='Microsoft Office Personal Edition 2003' OR displayname00 ='Microsoft Office Professional Edition 2003' OR displayname00='Microsoft Office Small Business Edition 2003' OR displayname00='Microsoft Office Standard Edition 2003') AND client0 = 1) AS office2003 ON Total.Name0 =office2003.Name0 LEFT JOIN ( SELECT DISTINCT sys.Name0 , displayname00 AS OfficeEdition , version00 AS OfficeVersion FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey =arp.machineid WHERE(displayname00 LIKE 'Microsoft Office Personal 2007' OR displayname00 LIKE 'Microsoft Office Professional 2007' OR displayname00 LIKE 'Microsoft Office Professional 2007 Trial' OR displayname00 LIKE 'Microsoft Office Professional Hybrid 2007' OR displayname00 LIKE 'Microsoft Office Professional Plus 2007' OR displayname00 LIKE 'Microsoft Office Professional Plus 2007 (Beta)' OR displayname00 LIKE 'Microsoft Office Standard 2007' OR displayname00 LIKE 'Microsoft Office Standard 2007 Trial' OR displayname00 LIKE 'Microsoft Office Ultimate 2007' OR displayname00 LIKE 'Microsoft Office Enterprise 2007' OR displayname00 LIKE 'Microsoft Office Ultimate 2007' OR displayname00 LIKE 'Microsoft Office Ultimate 2007' ) AND sys.client0 = 1) AS Office2007 ON Total.Name0 =office2007.Name0 LEFT JOIN ( SELECT DISTINCT sys.Name0 , displayname00 AS OfficeEdition , version00 AS OfficeVersion FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey =arp.machineid WHERE(displayname00 LIKE 'Microsoft Office 2010' OR displayname00 LIKE 'Microsoft Office Professional Plus 2010' OR displayname00 LIKE 'Microsoft Office Standard 2010' OR displayname00 LIKE 'Microsoft Office Professional 2010' OR displayname00 LIKE 'Microsoft Office Home and Student 2010' OR displayname00 LIKE 'Microsoft Office Home and Business 2010' OR displayname00 LIKE 'Microsoft Office Professional Plus 2010 (Beta)' OR displayname00 LIKE 'Microsoft Office Starter 2010 - English') AND sys.client0 = 1) AS office2010 ON Total.Name0 =office2010.Name0 LEFT JOIN ( SELECT DISTINCT sys.Name0 , displayname00 AS OfficeEdition , version00 AS OfficeVersion FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey=arp.machineid WHERE(displayname00 LIKE 'Microsoft Office 2013' OR displayname00 LIKE 'Microsoft Office Professional Plus 2013' OR displayname00 LIKE 'Microsoft Office Standard 2013' OR displayname00 LIKE 'Microsoft Office Professional 2013' OR displayname00 LIKE 'Microsoft Office Home and Student 2013' OR displayname00 LIKE 'Microsoft Office Home and Business 2013' OR displayname00 LIKE 'Microsoft Office Professional Plus 2013 (Beta)' OR displayname00 LIKE 'Microsoft Office Starter 2013 - English') AND sys.client0 = 1) AS office2013 ON Total.Name0 =office2013.Name0 LEFT JOIN ( SELECT DISTINCT sys.Name0 , displayname00 AS OfficeEdition , version00 AS OfficeVersion FROM system_disc sys LEFT JOIN add_remove_programs_data arp ON sys.itemkey=arp.machineid WHERE(displayname00 LIKE 'Microsoft Office 2013' OR displayname00 LIKE 'Microsoft Office Professional Plus 2016' OR displayname00 LIKE 'Microsoft Office Standard 2016' OR displayname00 LIKE 'Microsoft Office Professional 2016' OR displayname00 LIKE 'Microsoft Office Home and Student 2016' OR displayname00 LIKE 'Microsoft Office Home and Business 2016' OR displayname00 LIKE 'Microsoft Office Professional Plus 2016 (Beta)' OR displayname00 LIKE 'Microsoft Office Starter 2016 - English') AND sys.client0 = 1) AS office2016 ON Total.Name0 =office2016.Name0 Can someone with some SQL skills please help me? I have come up with a query that will list all the members of a collection based on collection ID, but I can't seem to figure out how to incorporate it.
  2. Hi All, Would like to know if there's a way to create a new Status Filter variable (Eg. %msgsys, %msgsrc and etc.) . At the start of the TS, the user who kicked-off the TS requires to authenticate before proceeding. Would like to capture the user's details (email, givenname and sn), store these into a variable (Eg. %email, %givenname & %surname) then pass it to the SCCM Status Filter Rules. Regards, ej
  3. Hello, at the moment I am testing sccm2012 because I have to deploy Windows 7 (with oem licenses) on a lot of exsting and new clients. I use a unattend.xml with that I disable/ skip the window to insert the windows 7 product key. Is there a chance that the client get the right computername and oem product key before it join the domain. Could the client search in a excel table (or small database) with its mac address for the corresponding computername and product key in the same line? With what toolkit (maybe MDT?) or script can I realize this? Thanks for your help Wolfgang
×
×
  • Create New...