site backup job manually

Start a scheduled SCCM 2012 site backup job manually

You might want to start a scheduled SCCM 2012 site backup job manually.
off course the Site Maintenance task Backup Site Server must be enabled and a valid backup path must be selected (UNC or local drive).



To start the scheduled backup job outside the scheduled time start services.msc


And then start the service SMS_SITE_BACKUP


You are also able to start the task inside the console by using Monitoring tab > System Status > Component Status > Ribbon > Start > Configuration Manager Service Manager

Drill down to SMS_SITE_BACKUP and query the component.

Then start the component.


Regardless of the method you use, you can follow the backup in the log file smsbkup.log

LISTLATESTAPPLICATIONCIS

SELECT MANUFACTURER, DISPLAYNAME, SOFTWAREVERSION, CI_UNIQUEID, MODELID, SDMPACKAGEVERSION, DATECREATED, LASTMODIFIEDBY FROM FN_LISTLATESTAPPLICATIONCIS(1033)

SQL for Disks space

Select v_R_System.name0,

v_R_System.Resource_Domain_OR_Workgr0 as Domain,
v_GS_LOGICAL_DISK.FreeSpace0,
v_GS_LOGICAL_DISK.Size0,
v_GS_LOGICAL_DISK.Caption0,
v_GS_LOGICAL_DISK.DriveType0,
v_R_System.Last_Logon_Timestamp0

from v_R_System

inner Join v_GS_LOGICAL_DISK on v_GS_LOGICAL_DISK.ResourceID = v_R_System.ResourceID

where v_GS_LOGICAL_DISK.DriveType0 = '3'
order by v_R_System.name0

SQL for Last_Logon_Timestamp0 and LastHWScan :

SQL for Last_Logon_Timestamp0 and LastHWScan :

select Distinct v_R_System.Netbios_Name0 as 'Device Name',
 v_R_User.Full_User_Name0 AS 'Employee Name',
  v_R_System.User_Name0 AS 'User ID',
  v_R_System.AD_Site_Name0,
  v_R_System.Active0,
  v_R_System.Client0,

   v_R_User.Mail0 AS 'Employee eMail',
    v_GS_OPERATING_SYSTEM.Caption0 AS 'Operating System',
v_GS_OPERATING_SYSTEM.InstallDate0 AS 'OSD Install Date',
  v_GS_SYSTEM_ENCLOSURE.Manufacturer0 AS 'Manufacturer',
   v_GS_COMPUTER_SYSTEM.Model0 AS 'Model',
   v_GS_SYSTEM_ENCLOSURE.SerialNumber0 AS 'Serial Number',
   v_r_system.Last_Logon_Timestamp0,LastHWScan

from v_R_System
Left Join v_R_User on v_R_User.User_Name0 = v_R_System.User_Name0
Left join v_GS_OPERATING_SYSTEM on v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceId
Left join v_GS_SYSTEM_ENCLOSURE on v_GS_SYSTEM_ENCLOSURE.ResourceID = v_R_System.ResourceId
Left join v_GS_COMPUTER_SYSTEM on v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceId
Left join v_GS_PC_BIOS on v_GS_PC_BIOS.ResourceID = v_R_System.ResourceId
Left join vCollectionMembers on vCollectionMembers.MachineID = v_R_System.ResourceId
Left join v_GS_LOGICAL_DISK on v_R_System.ResourceID = v_GS_LOGICAL_DISK.ResourceID
LEFT JOIN v_GS_WORKSTATION_STATUS HWSCAN on v_R_System.ResourceID = HWSCAN.ResourceID

FEW New queries

WMI query for application deployment for lower version: 

select distinct SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%XXXX%" and SMS_G_System_INSTALLED_SOFTWARE.ProductVersion < "10.0.0.10361"


WMI query for Workstations:

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceId = SMS_R_System.ResourceId where SMS_G_System_SYSTEM.SystemRole = "Workstation"


Query to get Application not installed machines report :

select SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId where SMS_G_System_COMPUTER_SYSTEM.Name not in (select distinct SMS_G_System_COMPUTER_SYSTEM.Name from  SMS_R_System inner join SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId inner join SMS_G_System_ADD_REMOVE_PROGRAMS on SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName Like "XXXXX for Windows 7.50  (XXXX)%" )

WMI Query for list of machine with disk space :

select SMS_R_System.Name, SMS_G_System_DISK.Name, SMS_G_System_DISK.Size, SMS_G_System_DISK.Status from  SMS_R_System inner join SMS_G_System_DISK on SMS_G_System_DISK.ResourceId = SMS_R_System.ResourceId



WMI query for application installed machines list : 

select distinct SMS_R_System.ResourceId, SMS_R_System.ResourceType, SMS_R_System.Name, SMS_R_System.SMSUniqueIdentifier, SMS_R_System.ResourceDomainORWorkgroup, SMS_R_System.Client from  SMS_R_System inner join SMS_G_System_INSTALLED_SOFTWARE on SMS_G_System_INSTALLED_SOFTWARE.ResourceID = SMS_R_System.ResourceId where SMS_G_System_INSTALLED_SOFTWARE.ProductName like "%XXXXX for Windows 7.50  (XXXX)%"


SQL query for asset report machine names with EmailID's :

select Distinct

v_r_system.netbios_name0,v_r_user.Full_User_Name0, v_r_user.User_Name0,v_r_user.Mail0,v_R_System.AD_Site_Name0,v_r_system.User_Domain0,v_r_system.Operating_System_Name_and0,

v_r_system.Last_Logon_Timestamp0
from v_r_user
join v_r_system on v_r_system .user_name0= v_r_user.User_name0

order by v_r_system.netbios_name0

Collection based application installed machines report :

Declare @CollID char(8)       
Set @CollID = 'SMSXXXXX1' 
SELECT Distinct
COMP.Name0 AS 'Machine Name',     
 COMP.UserName0 AS 'Username',
 v_R_system.User_Domain0 AS ' Domain Name',
 v_R_System.AD_Site_Name0,
ARP.Publisher0 AS 'Publisher',       
ARP.DisplayName0 AS 'Program',     
ARP.Version0 AS 'Version',       
ARP.InstallDate0 AS 'Install Date',     
 ARP.ProdID0 AS 'Product ID',
 v_R_system.Last_Logon_Timestamp0 
FROM v_Add_Remove_Programs ARP       
JOIN v_FullCollectionMembership FCM 
on ARP.ResourceID = FCM.ResourceID       
JOIN v_GS_COMPUTER_SYSTEM COMP           
on ARP.ResourceID = COMP.ResourceID
JOIN v_R_System on v_R_System.ResourceID = ARP.ResourceID     
WHERE FCM.CollectionID = @CollID           
AND ARP.DisplayName0 like '%XXXXXXX%'       
AND ARP.ProdId0 NOT LIKE '%(KB%)%'           
AND ARP.DisplayName0 NOT LIKE '%Update%'