Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

Is there a simple way to find just disk space (size) from QlikView script?

Hi All,

Is there anyway to find just disk size from QlikView. We are not interested to know sub folders,QVW sizes etc.

We just need Disk size (currently filled)

Thanks,

Chiru.

21 Replies
chiru_thota
Specialist
Specialist
Author

Thanks Peter.

I don't know Dos commands and  still struggling with Syntax.

Will it be some thing like below ?   Should I put server drive name in single/double quotes ?

Remote server drive name : \\XYZD01

EXECUTE powershell.exe "Get-WmiObject Win32_LogicalDisk -Computer XYZD01

Thanks,

Chiru

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Well, Microsoft's PowerShell (aka PS) has nothing to do with DOS or DOS commands. On the contrary, and as you can see from the EXECUTE statement in the second version of Steve's example document, PowerShell is a ... "shell" like cmd.exe but way better and incredibly more poiwerful and extensible than the DOC command line interface. It has a modern programming language-style syntax, is built on top of the .NET stack and part of all modern Windows versions (from v7 on, for XP you'll have to download an installer)


More power-speed-features-etc comes at a cost (of course). IMHO the PowerShell syntax looks like nothing else but PowerShell can easily mimick other command line interfaces (for example, dir is an alias for the native ps command Get-ChildItem with almost the same behavior). And there are many ways to perform a particular task, some of them just shorthand for the full syntax. No wonder that you might think a ps command looks a bit weird.


If you want to know more about parameters and options of specific PowerShell commands, open a Cml Line window, start PowerShell and type get-help command or get-help command -full. To leave PowerShell, type exit.


And to answer your question: just replace servername with the actual machine name of the remote computer for which you want to list disk drives. Omit the double slash, we're not using UNC paths here, just server names.


Best,


Peter