Skip to content

Instantly share code, notes, and snippets.

@andyrobbins
Last active May 22, 2017 21:22
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save andyrobbins/d861a0b6a7672cb7ab9525f89be5b885 to your computer and use it in GitHub Desktop.
Save andyrobbins/d861a0b6a7672cb7ab9525f89be5b885 to your computer and use it in GitHub Desktop.
from neo4j.v1 import GraphDatabase, basic_auth
driver = GraphDatabase.driver("bolt://localhost", auth=basic_auth("neo4j", "neo4jj"))
session = driver.session()
for result in session.run("""
MATCH (u:User)
RETURN COUNT(u)
"""):
TotalUserCount = int(result._values[0])
for result in session.run("""
MATCH (c:Computer)-[r:HasSession]->(u:User)
RETURN COUNT(DISTINCT(u))
"""):
UniqueUsersWithSessions = int(result._values[0])
# Thanks Tom Porter (@porterhau5) for correction
SessionPercentage = int((float(TotalUserCount) / float(UniqueUsersWithSessions)) * 100)
print str(SessionPercentage)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment