Get Sybase ASE hardware information -
i've search around , found useful procedures, such as:
sp_helpdevice sp_helpserver sp_configure
but no 1 can me. need information cpu, ram, os etc. there tool or procedure can me?
you can use xp_cmdshell
access os shell. you'll need have xp server installed , running procedure enabled.
xp_cmdshell command[, no_output] [return_status | no_wait]
the commands information depend on whether running on windows or *nix, here couple of examples documentation.
example 1 – (on windows) silently copies file named log on c drive file named log.0102 on drive: xp_cmdshell 'copy c:\log a:\log.0102', no_output
example 2 – (on unix) executes operating system’s ls command , returns list directory contents row of data: xp_cmdshell 'ls'
full documentation can found in reference manual: procedures
Comments
Post a Comment