Gerrit Mantel
 |
Programs | SQL_STORED_PROCEDURE - prc_ps_computersystem |  |
 |
 |
 |
| Name | prc_ps_computersystem |
| Type_desc | SQL_STORED_PROCEDURE |
| Comment | SQLServer Stored Procedure PURPOSE List properties of the local Computer System. Field list: - Name VARCHAR(128) NOT NULL (PK) - Manufacturer VARCHAR(128) NULL - Model VARCHAR(128) NULL - NumberOfProcessors INT NULL - NumberOfLogicalProcessors INT NULL - TotalPhysicalMemory BIGINT NULL This procedure uses the following method: - Create Powershell script on Windows temp folder - Run the Powershell script (with xp_cmdshell) and output results to csv-file to Windows temp folder - Use BULK INSERT to load the csv-file into a temp table - Select results from the temp table EXAMPLES EXEC [dbo].[prc_ps_computersystem]; USED OBJECTS - xp_cmdshell (extended stored procedure) (*) - powershell (external program) - dbo.prc_save_text_to_file (SP in local database) (**) - dbo.fun_FolderExist (UDF in local database) (**) - dbo.fun_DeleteFile (UDF in local database) (**) - dbo.fun_FileExist (UDF in local database) (**) - dbo.fun_TempFolder (UDF in local database) (**) (*) - Needs config parameter 'xp_cmdshell' = 1 (**) - Needs config parameter 'Ole Automation Procedures' = 1 HISTORY 2026-01-24 - Created procedure 2026-03-07 - Use UDF dbo.fun_TempFolder to get Windows temp folder TAGS <program> <description>List properties of the local Computer System</description> <generic>1</generic> <author>Gerrit Mantel</author> <created>2026-01-24</created> <lastmodified>2026-03-07</lastmodified> </program> |
| Description | List properties of the local Computer System |
| Minversion | |
| Generic | 1 |
| Author | Gerrit Mantel |
| Created | 2026-01-24 00:00:00 |
| Lastmodified | 2026-03-07 00:00:00 |
| Xp_cmdshell | 1 |
| Ole_automation | 0 |
| Subprogram_cnt | 5 |
| Sourcecode |  |
| Name | Type desc | Description | Minversion | Generic | Author | Created | Lastmodified | Xp cmdshell | Ole automation |
|---|---|---|---|---|---|---|---|---|---|
| fun_DeleteFile | SQL_SCALAR_FUNCTION | Delete given file(s) | 1 | Gerrit Mantel | 2017-10-10 00:00:00 | 2026-01-23 00:00:00 | 0 | 1 | |
| fun_FileExist | SQL_SCALAR_FUNCTION | Check if file exists | 1 | Gerrit Mantel | 2015-11-24 00:00:00 | 2026-01-23 00:00:00 | 0 | 1 | |
| fun_FolderExist | SQL_SCALAR_FUNCTION | Check if folder exists | 1 | Gerrit Mantel | 2015-11-24 00:00:00 | 2026-01-23 00:00:00 | 0 | 1 | |
| fun_TempFolder | SQL_SCALAR_FUNCTION | Get Windows temp folder directory | 1 | Gerrit Mantel | 2026-03-07 00:00:00 | 2026-03-07 00:00:00 | 0 | 1 | |
| prc_save_text_to_file | SQL_STORED_PROCEDURE | Write text variable to ansi file | 1 | Gerrit Mantel | 2017-01-25 00:00:00 | 2025-06-06 00:00:00 | 0 | 1 |