{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {},
   "outputs": [],
   "source": [
    "import os\n",
    "import sys\n",
    "\n",
    "workingDir = '/Users/dtomlinson/OneDrive - William Hill Organisation Limited/Mac/projects/vrops-api'\n",
    "sys.path.append(workingDir)\n",
    "\n",
    "import json\n",
    "import base64\n",
    "from vropsAPI import vropsAPI"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "vrops = vropsAPI.authenticate(\n",
    "    'https://sc1prapvro01/',\n",
    "    'svc_splunkVROPS@Group.WilliamHill.PLC',\n",
    "    'whgroup',\n",
    "    base64.b64decode(b'UmFjaW5nMjEyMg==').decode(),\n",
    "    verify=False,\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "vrops.getClusters()\n",
    "vrops.getClusterIdentifiers()\n",
    "allClustersList = vrops.getKeysList(vrops.allClusters)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['SC1PRINNOGEUXCCL01',\n",
       " 'BRSDRGEUX01',\n",
       " 'BRSDRCTXWN01',\n",
       " 'LD6-BRS-Hosts',\n",
       " 'BRSPRPCMGEUXCCL01',\n",
       " 'LD6DRGEUX01',\n",
       " 'BRSPRRTRGEWNCCL01',\n",
       " 'BRSPRTSRGEUXCCL01',\n",
       " 'LD6PTWHCUX01',\n",
       " 'Cluster-2',\n",
       " 'BRSPRDVOGEUXCCL01',\n",
       " 'SC1PRPCM01',\n",
       " 'SC1PRGEWN01',\n",
       " 'Performance-Test-Cluster',\n",
       " 'NJ2PRGE01',\n",
       " 'BRSPRCTXGEWNCCL01',\n",
       " 'SC1PRRETWN01',\n",
       " 'SC1PRMGMT01',\n",
       " 'BRSPRPCM01',\n",
       " 'AutoDeployHosts',\n",
       " 'GIBPRCONTXWHCUXCCL01',\n",
       " 'AutoDeployHosts-DVS',\n",
       " 'STJPRGEUX01',\n",
       " 'Cluster-1',\n",
       " 'SC1PRGEUX01',\n",
       " 'LD6PTGEUX01',\n",
       " 'MNLPRGE01',\n",
       " 'BRSPRSPLGEUXCCL01',\n",
       " 'LD6PTGEWN01',\n",
       " 'BRSTSRGEWN01',\n",
       " 'BRSPRCONTXWHCUXCCL01',\n",
       " 'BRSDRRETWN01',\n",
       " 'BRSPRMGMT01',\n",
       " 'BRSDVGEUX01',\n",
       " 'BRSTSGEWN01',\n",
       " 'BRSPRDROGEWNCCL01',\n",
       " 'BRSDRGEWN01',\n",
       " 'BRSPRTSOGEUXCCL01',\n",
       " 'GIBACITEST',\n",
       " 'LD6DRGEWN01',\n",
       " 'SC1PRCTXWN01',\n",
       " 'GIBPRGEWN01',\n",
       " 'STJPRSHGEUXCCL01',\n",
       " 'GIBPRSPUX01',\n",
       " 'LD6PRMGMT01',\n",
       " 'SC1PRSPLGEUXCCL01',\n",
       " 'SC1PRCONTXWHCUXCCL01',\n",
       " 'GIBPRMGMT01',\n",
       " 'SOFPRGE01',\n",
       " 'LD6DRWHCUX01',\n",
       " 'BRSPRTSRGEWNCCL01',\n",
       " 'BRSPRSHGEMGMTPRC01',\n",
       " 'GIBPRGEUX01',\n",
       " 'INDPRGE01',\n",
       " 'KRAPRGE01',\n",
       " 'BRSPRDRRGEWNCCL01',\n",
       " 'BRSPRDROGEUXCCL01',\n",
       " 'BRSPRTSOGEWNCCL01',\n",
       " 'WV1PRGE01',\n",
       " 'BRSTSGEUX01']"
      ]
     },
     "execution_count": 4,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "allClustersList"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "vrops.getHostsFromCluster(cluster='SC1PRCONTXWHCUXCCL01')\n",
    "vrops.getHostIdentifiers()\n",
    "allHostsList = vrops.getKeysList(vrops.allHosts)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "['sc1hsesx156.prod.williamhill.plc',\n",
       " 'sc1hsesx187.prod.williamhill.plc',\n",
       " 'sc1hsesx148.prod.williamhill.plc',\n",
       " 'sc1hsesx155.prod.williamhill.plc',\n",
       " 'sc1hsesx214.prod.williamhill.plc',\n",
       " 'sc1hsesx093.prod.williamhill.plc',\n",
       " 'sc1hsesx145.prod.williamhill.plc',\n",
       " 'sc1hsesx150.prod.williamhill.plc',\n",
       " 'sc1hsesx136.prod.williamhill.plc',\n",
       " 'sc1hsesx209.prod.williamhill.plc',\n",
       " 'sc1hsesx212.prod.williamhill.plc',\n",
       " 'sc1hsesx175.prod.williamhill.plc',\n",
       " 'sc1hsesx162.prod.williamhill.plc',\n",
       " 'sc1hsesx158.prod.williamhill.plc',\n",
       " 'sc1hsesx140.prod.williamhill.plc',\n",
       " 'sc1hsesx126.prod.williamhill.plc',\n",
       " 'sc1hsesx142.prod.williamhill.plc',\n",
       " 'sc1hsesx208.prod.williamhill.plc',\n",
       " 'sc1hsesx202.prod.williamhill.plc',\n",
       " 'sc1hsesx204.prod.williamhill.plc',\n",
       " 'sc1hsesx182.prod.williamhill.plc',\n",
       " 'sc1hsesx127.prod.williamhill.plc',\n",
       " 'sc1hsesx133.prod.williamhill.plc',\n",
       " 'sc1hsesx152.prod.williamhill.plc',\n",
       " 'sc1hsesx185.prod.williamhill.plc',\n",
       " 'sc1hsesx154.prod.williamhill.plc',\n",
       " 'sc1hsesx121.prod.williamhill.plc',\n",
       " 'sc1hsesx205.prod.williamhill.plc',\n",
       " 'sc1hsesx135.prod.williamhill.plc',\n",
       " 'sc1hsesx138.prod.williamhill.plc',\n",
       " 'sc1hsesx159.prod.williamhill.plc',\n",
       " 'sc1hsesx149.prod.williamhill.plc',\n",
       " 'sc1hsesx147.prod.williamhill.plc',\n",
       " 'sc1hsesx091.prod.williamhill.plc',\n",
       " 'sc1hsesx161.prod.williamhill.plc',\n",
       " 'sc1hsesx146.prod.williamhill.plc',\n",
       " 'sc1hsesx203.prod.williamhill.plc',\n",
       " 'sc1hsesx143.prod.williamhill.plc',\n",
       " 'sc1hsesx132.prod.williamhill.plc',\n",
       " 'sc1hsesx157.prod.williamhill.plc',\n",
       " 'sc1hsesx139.prod.williamhill.plc',\n",
       " 'sc1hsesx160.prod.williamhill.plc',\n",
       " 'sc1hsesx120.prod.williamhill.plc',\n",
       " 'sc1hsesx207.prod.williamhill.plc',\n",
       " 'sc1hsesx095.prod.williamhill.plc',\n",
       " 'sc1hsesx151.prod.williamhill.plc',\n",
       " 'sc1hsesx200.prod.williamhill.plc',\n",
       " 'sc1hsesx092.prod.williamhill.plc',\n",
       " 'sc1hsesx094.prod.williamhill.plc',\n",
       " 'sc1hsesx186.prod.williamhill.plc',\n",
       " 'sc1hsesx090.prod.williamhill.plc',\n",
       " 'sc1hsesx206.prod.williamhill.plc',\n",
       " 'sc1hsesx210.prod.williamhill.plc',\n",
       " 'sc1hsesx141.prod.williamhill.plc',\n",
       " 'sc1hsesx131.prod.williamhill.plc',\n",
       " 'sc1hsesx213.prod.williamhill.plc',\n",
       " 'sc1hsesx137.prod.williamhill.plc',\n",
       " 'sc1hsesx211.prod.williamhill.plc',\n",
       " 'sc1hsesx130.prod.williamhill.plc',\n",
       " 'sc1hsesx134.prod.williamhill.plc',\n",
       " 'sc1hsesx144.prod.williamhill.plc',\n",
       " 'sc1hsesx153.prod.williamhill.plc',\n",
       " 'sc1hsesx201.prod.williamhill.plc']"
      ]
     },
     "execution_count": 7,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "allHostsList"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "<Response [200]>\n",
      "Successfully imported the dictionary.\n",
      "<Response [200]>\n"
     ]
    }
   ],
   "source": [
    "for host in allHostsList:\n",
    "    vrops.getVMSFromHost(host)\n",
    "    vrops.getVMSIdentifiers()\n",
    "    allVMSIdList = vrops.getValuesList(vrops.allVMS)\n",
    "    allVMSNameList = vrops.getKeysList(vrops.allVMS)\n",
    "    \n",
    "    vrops.getStatsFromVMS(\n",
    "    begin=vrops.epochRelativeTime(vrops.epochNow, minutes=-11),\n",
    "    end=vrops.epochNow,\n",
    "    intervalType='MINUTES',\n",
    "    intervalQuantifier='5',\n",
    "    rollUpType='AVG',\n",
    "    resourceId=allVMSIdList,\n",
    "    statKey=['cpu|usage_average', 'config|hardware|num_Cpu'],\n",
    "    )\n",
    "    \n",
    "    vrops.exportVMData()\n",
    "\n",
    "    vrops.export\n",
    "    break"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "print(vrops.export)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.7.3"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}