Using Qlikview to Report on Server space

[#1]

I need to use Qlikview to do reporting on server space. I need to be able to use qlikview to connect to the server and be able to report on the following:

• Used Space on drive C and D
• Free Space available on C and D

Can someone please advise?

[kaushiknsolanki]

Hi,

Try below script to know the used space on a drive.

sub DoDir (Root)

for each File in filelist (Root&'\*.*')

LOAD '$(File)' as Name,

FileSize( '$(File)' ) as Size,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

next File

for each Dir in dirlist (Root&'\*' )

call DoDir (Dir)

next Dir

end sub

call DoDir ('C:')

Change C: to 😧 drive to know its size.

Once script loads just do a Sum(Size) to know the size of that drive.

Regards,

Kaushik Solanki

[#3]

Thanks Kaushik

I forgot to mention that the server space I want to report on is not where Qlikview document is hosted. So where do I specify the server name?