Digital Corner - Dane Read

SCCM - Change all Task Sequences boot image (powershell)

Published in SCCM 2012 June 21 2019 0

Get-CMTaskSequence | Set-CMTaskSequence -BootImageId "packageidDC0000000"

Get list of Devices not checked into SCCM for X days

Published in SCCM 2012 September 12 2018 0

i have recently been putting in more automation scripts to alert myself and others around me of things that are and are not working in the school,

Since most of my time is spread accross multiple sites i have been putting together tasks delegated to my team members and other staff that are able to follow things up such as in this case

DEVICES THAT HAVE NOT CHECKED IN FOR X Days (30 days for this script below.)

for now i have just generated the sql statement and will soon add it into my SCCM Subscriptions to email me and others of our team if actions need to be followed up.

in my sites database i use the following QUERY.

SELECT

A.Name0,

MAX (B.SerialNumber0) AS 'Serialnumber',

A.Manufacturer0,

A.Model0, C.Name0 AS 'Processor',

D.TotalPhysicalMemory0 AS 'Memory (KBytes)',

MAX ( E.Size0 ) AS 'Size (MBytes)',

MAX (F.MACAddress0) AS 'MAC Adress',

MAX (F.IPAddress0) AS 'IP Adress',

G.AD_Site_Name0 AS 'AD Site',

MAX (A.UserName0) AS 'Last user logged in',

H.Caption0 AS 'Operating System',

H.CSDVersion0 AS 'Service Pack',

G.Creation_Date0 AS 'Creationdate in SMS',

I.LastHWScan,

O.LastPolicyRequest

FROM

v_GS_COMPUTER_SYSTEM A,

v_GS_PC_BIOS B,

v_GS_PROCESSOR C,

v_GS_X86_PC_MEMORY D,

v_GS_DISK E,

v_GS_NETWORK_ADAPTER_CONFIGUR F,

v_R_System G,

v_GS_OPERATING_SYSTEM H,

v_GS_WORKSTATION_STATUS I,

vWorkstationStatus O

WHERE

A.ResourceID = B.ResourceID AND

A.ResourceID = C.ResourceID AND

A.ResourceID = D.ResourceID AND

A.ResourceID = E.ResourceID AND

A.ResourceID = F.ResourceID AND

A.ResourceID = G.ResourceID AND

A.ResourceID = H.ResourceID AND

A.ResourceID = I.ResourceID AND

A.ResourceID = O.ResourceID AND

O.LastPolicyRequest <= GETDATE() -30

GROUP BY A.Name0, A.Manufacturer0, A.Model0, C.Name0, D.TotalPhysicalMemory0, G.AD_Site_Name0, A.UserName0, H.Caption0, H.CSDVersion0, G.Creation_Date0, I.LastHWScan, O.LastPolicyRequest

SCCM - Automatic Deployment Rule Error run Check script

Published in SCCM 2012 May 22 2018 0

One of the issues i have come accross when deploying our automatic updates through SCCM in a proxy'd or firewalled environment is that sometimes the WSUS servers timesout. giving us several types of error codes.

SCCM - Compliance Settings - Business Hours

Published in SCCM 2012 May 16 2018 0 Tagged under

Setting Business Hours

Credential Updater 1.0

Published in Blog December 01 2017 0

Hi all,

A project i thought i'd share with you all, in which source code in c# & application is available here if needed. please feel free to modify and use as needed.
Since we have now implemented passwords to change every certain amount of days the calls for admin users needing to remap their drives and printers has started.

Building An Image - SCCM 2012 R2

Published in SCCM 2012 November 30 2017 0 Tagged under

Introduction into building an image with SCCM 2012r2 and capturing it for later deployment.

Safety Online - Office 365 For Students

Published in Education June 01 2017 0

Services	Description	Benefits to Your Child	Things You Need to Be Aware of
Exchange Online / Email for Students	This includes email, calendar, contacts, 50GB mailboxes.	ü More storage space ü Easy search of staff and students from the same school	! Your child can send and receive emails from anyone
Lync Online	This includes instant messaging and supports online meetings with video and audio.	ü Full experience of audio and video for online meetings ü Provides whiteboard capability in group discussion	! Your child is able to have private conversations with any students at his/her school ! Personal conversations are recorded in his/her email accounts
SharePoint Online	SharePoint supports announcements, tasks, calendar, blogs, wikis and document/picture libraries.	ü Support your child’s access to the school portal and class sites for a range of collaborative activities ü Your child’s access is restricted to his/her class and school
OneDrive for Business	This provides online storage in the cloud. Files can be shared with staff and students as needed.	ü 1 terabyte (TB) storage ü Your chi ld can jointly write and edit documents with other students	! Your child may share documents with students and staff from other schools
Office Web Apps	Web based Word, OneNote, PowerPoint and Excel.	ü Enables your child to create and edit Word, OneNote, PowerPoint and Excel documents with any modern browser
Yammer	Yammer is a private social network. Schools can post events, news, activities and pictures within their group.	ü Allows your child to actively collaborate with his/her class about school work ü Allows your child to socialise with other students online ü Relationship building with other students	! Your child can see and be ‘friends’ with students / staff from other Victorian schools ! Your child may have access to content that is not restricted to his/her age
Office Video	Office Video provides schools with a destination for posting, sharing and discovering video content.	ü Promotes knowledge sharing ü Provides channels to school activities	! Your child can search for students / staff from other Victorian schools