def updatediskspaces(server, username,userpass,reason)
  ActiveRecord::Base.establish_connection(:adapter  => "mysql",
                                                          :host     => "192.168.43.16",
                                                          :database => "podstatus",
                                                          :username => "root",
                                                          :password => "root" )

  begin
  swbemloc = WIN32OLE.new("WbemScripting.SWbemLocator")
  mgmt = swbemloc.ConnectServer(server,"root\\cimv2", username,userpass)
  mgmt.ExecQuery("select * from Win32_LogicalDisk Where DeviceID = \"F:\"").each do |disk|
    @freespace=disk.FreeSpace.to_i
    @totalspace=disk.Size.to_i
    @usedspace=@totalspace-@freespace
  end
  rescue
    @totalspace="---"
    @usedspace="---"
    reason="Failed to take Snapshot"
  end
  scripthash = arescriptsrunning(server,username,userpass)
  @diskspace = Diskspace.create(:pod => server,
                                              :used_space => @usedspace,
                                              :total_space => @totalspace,
                                              :reason => reason,
                                              :added_date => Time.now,
                                              :mirror_status => scripthash[:mirror_status],
                                              :cruncher_status => scripthash[:cruncher_status])


end