Skip to content
IT-Admins
a website from a systems administrator for systems administrators
  • Home
  • IT-Admins tool
    • Features
    • Scenarios
    • Screenshots
    • Release notes
    • FAQ
    • Download
    • Online Manual
      • Overview
      • Generic search functions
      • Configuration
      • Domain Users
      • Domain Groups
      • Domain Computers
      • Domain Contacts
      • NTFS ACLs
      • Long Paths
      • Directory compare
      • Search function
  • IT Assets database
    • IT Assets DB Video
    • Features
    • Installation
    • Release Notes
    • Update to the newest version
    • Download
    • Online manual
      • Overview
        • The floating / roaming task execution
      • Using the the sys search
      • Main menu
      • Workstations
      • Monitors
      • Departments
      • Printers
        • Printer models and supplies
        • Toner inventory
      • Incidents
      • Software and licenses
      • LDAP change reporting / synchronization
        • Employees
        • LDAP Groups
      • IP addresses – IPAM
      • DNS management
      • Servers and equipment
        • databases
        • backup reviews
        • Certificate management
        • Webserver Management
      • Vendors and contacts
      • Links and URLs
      • Reminders
      • Purchases
      • Expenses
      • Project management
        • Project tasks
      • Phones and DIDs
      • LDAP compare
      • VMware compare
      • Wiki aka. knowledge base
      • Owner / rights matrix
      • Application users
      • Change Requests
      • Foreign data views
        • RADIUS log example
        • SysLog example
      • System configuration views
        • Sys Config
        • Sys columns
        • Sys Errors
      • MAC address search
      • IT Supplies
      • Notes (applies to many modules)
      • TAGs
      • Checklists
      • History reports / emails
    • Information for developers
  • IT Printer Management
    • Installation
    • Download
    • Online Manual
      • Executing the script
      • Using the Sys-Search
      • Managing printers
      • Reviewing the log
      • User to printer (v2)
      • Computer to printer (v2)
  • IT Search
    • How it works
    • Release Notes
    • Download
    • Installation
    • Online Manual
      • Applying updates
      • Search Providers
      • Configuration
      • Error Log viewer
      • Active Users
      • Monitoring and Statistics
      • Backup and Restore
  • Blog
  • Contact

Tag: database

Auditing network users against HR lists etc.

September 25, 2020 Florian Rossmark

Auditing network users against HR lists – a topic that is often overlooked or causes some headache due to e.g.…

Continue Reading →

Posted in: prtg Filed under: active directory, audit, database, Office 365, prtg, security

Summarize SQL server database file size information as a single row

May 21, 2019 Florian Rossmark

The SQL script below will show you the summarized database file size and database log file sizes on the current…

Continue Reading →

Posted in: prtg Filed under: database, monitoring, prtg, sql

Raspberry PI and Microsoft SQL databases

January 31, 2019 Florian Rossmark

Raspberry PI can read and write on a Microsoft SQL server database. In order to accomplish this you follow the…

Continue Reading →

Posted in: Uncategorized Filed under: database, python, raspberry, script, sql

SQL Express SQLState 08001 and Error 17

September 10, 2018 Florian Rossmark

One of the challenges especially with SQL Express is that you need to enable some protocols on the network level…

Continue Reading →

Posted in: Uncategorized Filed under: database, sql

Microsoft RADIUS / NPS SQL logging

September 6, 2018 Florian Rossmark

An issue or question I see again and again – proper RADIUS logging with Microsoft NPS / Network Policy Server.…

Continue Reading →

Posted in: Uncategorized Filed under: database, logging, radius, server, sql

Automate your SUS clean up

June 26, 2018 Florian Rossmark

Many companies rely on WSUS respective SUS services from Microsoft – aka. Windows Server Update Services as internal source and…

Continue Reading →

Posted in: powershell Filed under: cleanup, database, performance, powershell, script, server, sus

Script based SQL Express backups

June 19, 2018 Florian Rossmark

SQL Express is widely used but has huge downside, there is no SQL Agent available. Even Windows internal databases, especially…

Continue Reading →

Posted in: script Filed under: backup, database, script, server, sql

Solarwinds Web Helpdesk – Slack alerts

June 1, 2018 Florian Rossmark

This was originally posted here by myself: https://thwack.solarwinds.com/thread/114863 Solarwinds WebHelpDesk is very powerful, but for those who use Slack as communication…

Continue Reading →

Posted in: powershell Filed under: database, powershell, server, slack

SQL Database backup monitoring

Florian Rossmark

The following article was originally posted here by myself: https://kb.paessler.com/en/topic/79665-sql-database-backup-monitoring SQL backups and their monitoring is one of the most important…

Continue Reading →

Posted in: prtg, Uncategorized Filed under: backup, database, prtg, script, sql

Search this site

Recent blog posts

  • Windows Print Server Aliases January 13, 2021
  • Bypassing Windows 10 UAC for Unknown Publishers December 8, 2020
  • Make Microsoft TEAMS the default IM application October 15, 2020
  • Monitor group memberships in Active Directory with PRTG October 13, 2020
  • Auditing network users against HR lists etc. September 25, 2020
  • Monitoring relative printer page counts with PRTG June 17, 2020
  • Office 365 licenses and activated features per user March 24, 2020
  • PRTG and Cisco ASA VPN monitoring March 19, 2020
  • Amount of locked out accounts October 25, 2019
  • RDS – Fix broken local RDS links in start menu October 3, 2019
  • PRTG and VMware 6.7 vCenter host hardware status August 8, 2019
  • Search the Windows Security Eventlog for a string / text August 7, 2019
  • Active Directory password reset events and group change events August 1, 2019
  • APC InRow A/C error monitoring with PRTG July 19, 2019
  • Summarize SQL server database file size information as a single row May 21, 2019
  • Move user Documents and Desktop to OneDrive April 18, 2019
  • Compare a TRACEROUTE against an expected route March 6, 2019
  • Request a DNS based web site directly from an IP address March 6, 2019
  • Using PRTG to monitor manufacturing machines March 6, 2019
  • Find user account lockout events February 20, 2019

Tags

account active directory apc automate backup backup exec cleanup database dfs dns domain join eventlog excel expiration filesystem gpo html index ip javascript ldap lockout monitoring notification office Office 365 outlook password performance powershell print profile prtg rds script security server slack SNMP sql sus UEFI veritas vmware windows
  • Terms & Conditions
  • SPICEWORKS
  • LOPSA
  • RSS
  • LinkedIn
  • ITML
  • XING
Privacy Policy
Copyright © 2018 Florian Rossmark — Velux WordPress theme by GoDaddy