How to run Powershell scripts with a Service Account to access ConfigMgr 2012 SP1

Posted in PowerShell, SCCM 2012, Scripting, System Center

When using a service account to run for instance my “cleaning ConfigMgr” Powershell script you may run in to an error. When trying to access the Windows PowerShell drive that is mapped to your Primary Site you will receive the following error: “set-location : Cannot find drive. A drive with the name <primary site> does not exist.” (see figure on the left)...

Read More»

Fully Automate Your Quarterly Build & Capture Process

Posted in How-To, Hyper-V, Hyper-V 3, PowerShell, SCCM 2007, SCCM 2012, Scripting

Best practices has your desktop deployment not installing Windows via the setup.exe each and every time, but rather deploying a captured Windows image and building off of that. You choice of a thin or fat image is up to you and your environmental needs, but periodically executing a Build & Capture (B&C) routine that installs Windows and all the latest...

Read More»

How to: Add a “Delete Deployment” Action to Right-Click Actions in ConfigMgr 2012

Posted in CM2012

Posted in CM2012ConfigMgrSCCM

Another item Greg Ramsey demo’d at MMS. Read his full post here. Many times I find myself looking at Monitoring->Deployments in the ConfigMgr 2012 admin console, and find deployments that should be removed. The “out of the box” process to remove deployments is to browse to the object being deployed (Package, Application, Setting, TS, etc.), [...]

Read More»

Video card with Sound card.

Posted in CM07, CM12, Code, SQL, SSRS, System Center

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

 

select distinct 
    R.Netbios_Name0 as 'Name',
    R.User_Name0 as 'User',
    CS.Manufacturer0 as 'Manufacturer', 
    CS.Model0 as 'Model',
    BIOS.SerialNumber0 as 'Serial',
    SD.Name0 as 'Processor', 
    RAM.TotalPhysicalMemory0 as 'Memory',
    VC.Name0 as 'Video Card', 
    VC.VCRam as 'Video Card RAM',
    Sound.Description0 as 'Sound card'
from  
    dbo.v_R_System R 
    inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId 
    inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID 
    inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId 
    inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId 
    left outer join dbo.v_GS_SOUND_DEVICE Sound on Sound.ResourceID = R.ResourceId 
    left outer join (
        select     
            VC.ResourceID,
            VC.Name0,
            Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'VCRAM'
        from 
            dbo.v_GS_Video_Controller VC 
        Where
            VC.Name0 != 'ConfigMgr Remote Control Driver'
            and VC.AdapterRam0 is not null) VC on  R.ResourceID = VC.ResourceId 
where 
    SD.CompatibleIDs0 = 'ACPI\Processor'

Read More»

Video Card Details v2

Posted in CM07, CM12, Code, SQL, SSRS, System Center

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

select distinct 
    R.Netbios_Name0 as 'Name',
    R.User_Name0 as 'User',
    CS.Manufacturer0 as 'Manufacturer', 
    CS.Model0 as 'Model',
    BIOS.SerialNumber0 as 'Serial',
    SD.Name0 as 'Processor', 
    RAM.TotalPhysicalMemory0 as 'Memory',
    VC.Name0 as 'Video Card', 
    VC.VCRam as 'Video Card RAM'
from  
    dbo.v_R_System R 
    inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId 
    inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID 
    inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId 
    inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId 
    left outer join (
        select     
            VC.ResourceID,
            VC.Name0,
            Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'VCRAM'
        from 
            dbo.v_GS_Video_Controller VC 
        Where
            VC.Name0 != 'ConfigMgr Remote Control Driver'
            and VC.AdapterRam0 is not null) VC on  R.ResourceID = VC.ResourceId 
where 
    SD.CompatibleIDs0 = 'ACPI\Processor'

Read More»

Video Card Details v2

Posted in CM07, CM12, Code, SQL, SSRS, System Center

For full details please see

http://social.technet.microsoft.com/Forums/en-US/configmgrreporting/thread/c42ba8cf-02a5-4e2e-8d20-39b05a4a5740

select distinct 
    R.Netbios_Name0 as 'Name',
    R.User_Name0 as 'User',
    CS.Manufacturer0 as 'Manufacturer', 
    CS.Model0 as 'Model',
    BIOS.SerialNumber0 as 'Serial',
    SD.Name0 as 'Processor', 
    RAM.TotalPhysicalMemory0 as 'Memory',
    VC.Name0 as 'Video Card', 
    VC.VCRam as 'Video Card RAM'
from  
    dbo.v_R_System R 
    inner join dbo.v_GS_X86_PC_MEMORY RAM on RAM.ResourceID = R.ResourceId 
    inner join dbo.v_GS_COMPUTER_SYSTEM CS on CS.ResourceID = R.ResourceID 
    inner join dbo.v_GS_PC_BIOS BIOS on BIOS.ResourceID =R.ResourceId 
    inner join dbo.v_GS_SYSTEM_DEVICES SD on SD.ResourceID = R.ResourceId 
    left outer join (
        select     
            VC.ResourceID,
            VC.Name0,
            Convert(VarChar, VC.AdapterRam0 / 1024) + ' MB' as 'VCRAM'
        from 
            dbo.v_GS_Video_Controller VC 
        Where
            VC.Name0 != 'ConfigMgr Remote Control Driver'
            and VC.AdapterRam0 is not null) VC on  R.ResourceID = VC.ResourceId 
where 
    SD.CompatibleIDs0 = 'ACPI\Processor'

Read More»
123›»