vikassukhija/downloads

AD Health Check, Send HTML Email, Ping machines, Encrypt Password,Bulk Password,Microsoft Teams,Monitor Certificate expiry, Monitor cert expiry, AD attributes, IP to Hostname, Export AD group, CSV to SQL,Shutdown, Restart, Local Admin, Disk Space, Account expiry,Restore Permissions, Backup permissions, Delete Files Older Than X-Days, export DHCP options,Read Registry,Distribution group AD attributes,Monitor Windows Services,Export Reverse DNS,Task Monitor,Monitor and alert, Exchange Health check,Get Network Info, Export AD Attributes,AD group members, Office 365 Group member, SQL to CSV, Outlook save send attachments, Upload files to FTP,Exchange – Total Messages Sent Received, Set Teams Only Mode, Intune Duplicate Device,Intune Cleanup Not Evaluated, Ownership and Grant Permissions, Write Create Modify Registry , Organization Hierarchy from AD,Azure AD Privileged Identity Management,Intune – Export MAM Devices,Intune Marking devices as Corporate, Dynamic to Static Distribution Group,Monitor Alert Office 365 services,Group Member Count,Bulk Addition external users sharepoint, ADD to Exchange online License Group,All in One Office 365 Powershell,Bulk Addition of Secondary Email, Automate move mailboxes to o365, Addition Modification Termination Exchange users, Monitoring Unified Messaging port,Unified Messaging Extensions Report, Set Default Quota for SharePoint,Bulk Contact Creation and Forwarding, Uploading and Downloading files sftp, Monitoring Sftp file and download, Office 365 groups Write back, CSV parser, Email address update, Email address modify, MDM enrollment, Welcome Email, Intune Welcome Email, remove messages, remove email, SKOB to AD, SKOB to group, PowerApps report, Powerautomate Report, Flow report, Server QA, Server Check List, O365 IP range, IP range Monitor, o365 Admin Roles, memberof extraction, CSV to Excel, Skype Policy, UPN Flip, Rooms Report, License Reconciliation,Intune Bulk Device Removal, Device Removal, Clear Activesync, Lync Account Termination,Lync Account Removal, Enable office 365 services, Enable o365 Services, Export PST, Site collection Report, Office 365 Group Sites, System Admin,ActiveSync Report,White Space,Active Directory attributes, outlook automation, Intune Detect App, Distribution list Fix, Legacy DN, start service, stop service, disable service, Message tracking, Distribution lists report,Distribution groups report,Quota Report, Auto reply, out of office, robocopy multi session, Home Folder, local admin, Database, UPN SIP Mismatch, Recoverable deleted, teams number, Number assignment, teams phone, AD Group Hierarchy, Hierarchy membership, Sync Groups, Powerapps, Powerapps DLP, AzureAD application, Azure AD Secret, AzureAD Certificate, AzureAD Cert, Powerapps DLP, Download SPO file, Download Sharepoint file, Sharepoint item download

System Administration Repository

https://techwizard.cloud/

Downloads https://techwizard.cloud/downloads/

######################Hyperlinks for Documentation for each script##################

• Active Directory Health Check
• Send HTML Email and attachment Powershell
• Ping Machines and report in Excel
• PowerShell – HostName to IP along with Ping in Excel
• Encrypt Password and use it in Powershell Script
• Bulk Password Reset – Active Directory
• Microsoft Teams Report for Office 365 Tenant
• Certificate expiry Alert
• Update Active Directory User attributes from CSV
• Export AD group members – nested / recursive group members
• PowerShell – IP to HostName along with Ping in Excel
• Import from CSV to SQL Table
• Shutdown / Restart via PowerShell
• Add User to Local Administrator on Remote Machine
• Disk Space Report – Excel
• Account Expiry Email Alert
• Backup and Restore permissions – Powershell
• Delete Files Older Than X-Days Except Certain Subfolders
• Export DHCP Scope Options Values
• Read Registry from multiple servers via Powershell
• Update Active Directory User attributes from CSV – GUI
• Distribution group update based on AD attributes – PowerShell
• Monitor Windows Services status Remotely
• Export Reverse DNS PTR Records
• Schedule Task Monitor Script
• Monitor and alert Windows Services status
• Exchange 2010 Health Check
• Get Network Info from list of servers – DNS, IP, WINS
• Export Active Directory attributes to Excel
• Export AD group members – CSV format
• Updated members of Office 365 Group based on AD Group or Distribution list
• Export AD group members – nested / recursive group members using Quest
• Export to CSV from SQL Table
• Outlook Automation- Save and Send attachments – Powershell
• Upload files to FTP server
• Exchange – Total Messages Sent / Received with Size
• Set Teams Only Mode Based AD Group
• Intune Duplicate Device Cleanup
• Export AD group members – nested / recursive members for multiple groups
• Take Ownership and Grant Permissions
• Exchange Health Status Check
• Write, Create & Modify Registry for multiple servers via Powershell
• Export Organization Hierarchy from AD to Excel
• Extract Report – Azure AD Privileged Identity Management
• Intune – Export MAM Devices Report
• Intune Marking devices as Corporate
• Dynamic to Static Distribution Group
• Monitor and Alert for New Office 365 services
• Group Member Count Daily Report
• Bulk Addition of External Users to Sharepoint online Site
• ADD to Exchange online License Group based on User Status
• All in One Office 365 Powershell Connect
• Bulk Addition of Secondary Email address from CSV
• Automate move the New mailboxes to Cloud
• Report on Addition, Modification, Termination of Exchange users
• Monitoring Unified Messaging Worker Process Port Number
• Exchange Online Unified Messaging Extensions Report
• Intune Cleanup Not Evaluated Devices
• Set Default Quota for SharePoint Online Sites including office 365
• Bulk Contact Creation and Forwarding Exchange Hybrid
• Uploading and Downloading files from Secure FTP
• Monitoring Secure FTP file and Download it via Power-shell
• Office 365 groups Write back without Azure AD Premium
• CSV Parser for Event logs
• Email Addresses Update based on Distribution List
• Update Active Directory User attributes from CSV
• Intune – MDM Enrollment Welcome Email
• Remove Messages Based on Message Class – Outlook Powershell
• Add all Skype for Business Online Users to AD group
• PowerApps and Microsoft Flow Report
• Server Install Check List
• List all OneDrive Sites – HTML report
• Office 365 IP address Range Monitor
• Assign Office 365 Admin Roles in Bulk via Text File Input
• AD MemberOf Extraction from list of Users
• Convert any CSV to Formatted Excel file
• SKYPE Policy Compliance Script
• UPN Flip for Office 365 Users
• Exchange Online Rooms Report
• Extract office 365 Role Admins
• Office 365 License Reconciliation
• Intune Bulk Device Removal Tool
• Clear ActiveSync Stale Partnerships
• Clear ActiveSync Stale Partnerships – ExchangeOnline
• Lync Account Termination
• Enable o365 Services – input users via text file
• Export PST for multiple users from Particular Folder
• SharePoint Online Site Collection owner Report
• Office 365 Group Sites ownership Report
• Office 365 Group Sites ownership Report v2
• PowerShell System Admin Module
• ActiveSync Report Exchange Online
• Exchange 2007 Database White Space Report
• Export Active Directory attributes to Excel based on OU
• Publish Sharepoint 2010 Site Collection Report
• Outlook Automation- Move emails – Powershell
• Exchange 2013 Health Check
• Intune – Check Particular APP installation on Devices
• Distribution List Message Delivery Restrictions FIX
• Import Legacy exchange DN from CSV
• Bulk start, stop, disable of windows services
• Message Tracking Multiple users
• Distribution Groups Report – Exchange 2007/2010
• Exchange 2007 and 2010 Quota Report
• Auto Reply multiple Users
• PowerShell Robocopy launching multiple concurrent sessions
• VBScript – robocopy for launching multiple concurrent sessions
• PowerShell – Ping Machines and report in Excel
• PowerShell Creating a Home Folder for Users
• Disk Space and Services Threshold Monitoring
• Exchange Server Health Check
• Bulk ADD Remove from Local Admin via CSV
• Failed to execute Troubleshoot-DatabaseSpace.ps1
• Check UPN and SIP match Skype for Business Online
• Message tracking script
• Recoverable deleted items Report
• Teams – Exporting Users In Emergency Location
• PowerShell – Teams Phone number Assignment
• Distribution Group based on Head of Organization
• Add users to acceptmessagesonlyfrom
• Exchange 2010 Database White Space Report
• Get Group Distinguished Name
• Delete files older than X days
• PowerShell: Check Lync Services and start if not running
• Get User Distinguished Name
• Sync Multiple Groups to Single Group
• Azure PIM Admin Report Version 2
• Track Changes to Active Directory Users Attributes
• Export AD group members – nested / recursive using Quest input via text file
• Disable AD users in Bulk
• Export DHCP Statistics
• Install SharePoint 2010 Language packs
• Active Directory Health Check V2
• Office 365 License Assignment Dates
• Available Team Numbers Report
• Password HASH Sync – Password expiry Set to Never Expire
• PowerShell – AD Group to Azure AD Cloud Only Group Sync
• Restrict User Accounts From OU To Computer List
• PowerShell: Update AzureAD Group membership from text file
• AzureAD Application Report
• AzureAD Application Cert and Secret Expiry Alert
• Powerapps DLP Policy – Exclude Teams Environments Script
• Powershell Script to monitor folder for files
• Monitoring Event id thru Powershell
• Export Sharepoint List to CSV
• Password Expiry Email Alert Counter Days Left
• Multi Geo Move Scripts
• PowerShell – Export Import Scheduled Tasks
• “Modify Accept Messages only from” for Distribution List
• Creating SharePoint Dashboard using Chart WebPart
• Lync 2010 Health Check
• Convert Structured TEXT to CSV format
• Exchange GAL error Analysis – Eventid 9325
• Exchange 2010 w3wp process High CPU utilization
• Exchange DAG Backup Reporting
• Sharepoint Content Database Size Report
• IIS APPPool Monitoring Using PowerShell & PSEXEC
• SharePoint Item Level Permissions
• Office 365 Users Service Usage Report
• Room Mailboxes Calendar Permissions Report
• PowerShell – Download File from SharePoint Document Library
• AzureKeyVault – Synchronize Secrets to Local Server
• Automate Disable Self-Service Purchase option Office 365 Products
• PowerShell – Available Team Numbers Report V2
• Fetch Monthly Count of SharePoint List Requests
• AzureAD Stale Devices Cleanup
• Monitor PowerAutomate Flows for Failures
• Python – Connect SFTP and Upload files
• Monitor Scheduled Task Failures
• PowerShell – Download Excel from SharePoint and Export to ServiceNow Tables
• Python – Remove Specific AD groups From Target Users
• Bulk Update Primary User for Intune Devices
• PowerShell – Azure AD User last login Report
•  Python – Azure AD User last login Report
• Active Directory Printer Inventory Report
• Python – Reading SharePoint List Delegated Application Permissions
• Sync Azure active directory group to On-premises Active Directory
• PowerShell – Report on AZURE SQL Servers in Organization
• Read SharePoint List to ADD and Remove members from AD Group
• PowerShell – Report on Azure Disks across Organization
• Alert – Duplicate Objects in AD Created by Replication Conflict
• PowerShell – Report on AZURE Storage Account Usage in Organization
• AWS – EC2 inventory Report across Organization
• AD OU Creation and Deletion Alert
• PowerShell – Sync CSV to SharePoint List

downloads's Issues

Space in Table

Hi Vikas, Is there a way to add a space between each servers in the table in the service Status?

script?

The report is blank

Hi Vikas,
I've updated the script to include ServicePrincipalIDs and ServicePrincipalNames based on the steps given on Techwizard but it generates a blank file. Can you tell me what am I missing?
The script is saved in a Temp Folder and I manually created a Report folder in it where the blank excel file is created.

Comment states removing devices from Intune

Downloads/IntuneDeviceApplicationFind.ps1

Line 154 in 1c12b46

###########Remove these devices from Intune#################

I believe this might just be worded poorly, but the follow section of code does not remove any devices from intune, but instead queries intune for every device as to what applications are installed, and adds the intune devices to an array which is later put into the csv report.

Question about FixPHSPasswordExpiry.ps1

Hello VikasSukhija.
Тhanks for the script. This works great.
Can you tell me how to configure the "New Management Role" to run this script?
It is not safe to run the script with administrator rights. Thanks

I do not understand

Would you mind explaining a little about this repo? What it is? WHat is its purpose?

mail format

Do you know what format use Microsoft to store its mails in OST/PST files? HTML/EML/MESSAGE/etc.

AdvertisingFail

Hi,
I'm getting error in report:
AdvertisingTest - AdvertisingFail
And when i'm trying to run this part manualy i see next

Testing server: domain\hostname

Starting test: Advertising

  Fatal Error:DsGetDcName (hostname) call failed, error 1722

  The Locator could not find the server.

  ......................... hostname failed test Advertising

Windows Server 2012R2

How can i fix this?