Questions tagged [spiceworks]

Spiceworks is a software development company headquartered in Austin, Texas. It was formed in early 2006 by Scott Abel, Jay Hallberg, Greg Kattawar, and Francis Sullivan to provide a Facebook-like community integrated with a free ad-supported

Spiceworks is a software development company headquartered in Austin, Texas. It was formed in early 2006 by Scott Abel, Jay Hallberg, Greg Kattawar, and Francis Sullivan to provide a Facebook-like community integrated with a free ad-supported

http://en.wikipedia.org/wiki/Spiceworks

29 questions
4
votes
5 answers

Best way to sort by IP addresses in SQL

I connect to my SpiceWorks database via PHP using the SQLITE3 PDO. I am trying to display a list of devices in order by IP address. Here is my current query: SELECT name, ip_address FROM `devices` ORDER BY ip_address The problem with this is that…
AJ Birone
  • 151
  • 2
  • 9
2
votes
2 answers

How to redirect https://ip.address to https://domain

Actually my concern was to redirect the both internal and external IP addresses to the domain name and any http://domain traffic to https://domain, which I have achieved by adding these lines in httpd.conf file: #Redirect IP to domain…
2
votes
1 answer

SQLite X'...' notation with column data

I am trying to write a custom report in Spiceworks, which uses SQLite queries. This report will fetch me hard drive serial numbers that are unfortunately stored in a few different ways depending on what version of Windows and WMI were on the…
Jim Sanders
  • 521
  • 1
  • 4
  • 10
1
vote
2 answers

How can I change a table td width using CSS in Spiceworks?

I’m trying to make a small change on a CSS for Spiceworks. This is the line that I want to change: Now this code: SPICEWORKS.utils.addStyle('body{background-color:blue}'); changes the bg color…
user181891
  • 101
  • 1
  • 3
  • 12
1
vote
1 answer

Spiceworks page loading slow, cant use apache cache

So the page is loading slow... Wants do download 4.4MB of page according to pingdom. I tried using disk cache, but spiceworks wont start up when adding the configurations to httpd.conf httpd.conf: ServerRoot "C:/Program…
1
vote
1 answer

Connect to SQlite (Spiceworks) database from ireports (Jaspersoft)

I'm trying to connect to SQLite db from Jaspersoft ireports. I was able to create a datasource successfully but when I create a report using the datasource it gives me below error message. java.sql.SQLException: file is encrypted or is not a…
1
vote
2 answers

Regex searching for time doesn't want to be non-greedy

I'm trying to run a regex in Spiceworks to parse through email headers to select the first instance of time for ticket assignment purposes. The regex itself works, but it picks up all instances of time rather than just one. Here's the regex:…
user3761389
  • 25
  • 1
  • 5
1
vote
1 answer

Conditional SUM not returning any value

Writing an SQL query to get a device count out of spiceworks. I need to get the device type, the model, how many are in use and how many are unassigned. Currently anything thats unassigned is marked as decommissioned. So I have the following query …
DBunting
  • 38
  • 6
1
vote
0 answers

Couldnt solve a hspice syntax error

I'm new to hspice and this is a very basic question. .dc vin VDD VDD 1 .print v(out) par('abs(i(vVDD)*VDD)') v(d2) .measure dc avg_leak_low=par('abs(i(vVDD)*VDD)') TRIG v(in) VAL= VDD TD=slew I'm following the syntax but I'm getting an…
1
vote
1 answer

Add average time to last row of query using sqlite

I have the following report that runs on a Spiceworks server weekly for our IS and IT departments to use as a metric for how long it takes us to assign helpdesk tickets. It selects the following: ticket ID ticket create date calculates the time it…
Andrea
  • 13
  • 4
1
vote
0 answers

Javascript works in Firefox, but not in Chrome or IE

I'm developing a plugin for Spiceworks that reformats a block of text. Unfortunately it only works in Firefox, and not in Chrome or IE. plugin.includeStyles(); function log(msg) { throw new…
0
votes
3 answers

How to get a value from a combobox in javascript

I have this function and I want to make the var category to have the value of the combobox that has the id #ticket_category_clone What am I doing wrong? function check () { var category="#ticket_category_clone"; if…
user181891
  • 101
  • 1
  • 3
  • 12
0
votes
1 answer

How to force a dropdown list to behave like a list box using javascript

I need to add multiple attribute to a select list, but unfortunately the dropdown list is not editable through HTML since it is a drag and drop feature of a CMS (Spiceworks user portal) I am using. The CMS is quite outdated; my only other option is…
Jamie
  • 1,579
  • 8
  • 34
  • 74
0
votes
3 answers

I would like to add a backgound image

I have the page exactly like I would like it to look. Now looking at it i wish I would have added a background image. Is there a simple way around this. I know the code may look a little funny but this is how Spiceworks corrects the code.
user99987
  • 13
  • 3
0
votes
1 answer

I cant get a button to link to sending an email

I am making a meet the staff page for our help desk. Even with everything looking good i am really struggling to make the contact button clickable to send an email. i can easily add a linkable option to email but that looks tacky. i have a feeling…
user99987
  • 13
  • 3
1
2