Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

None – I will backup manually
12:00AM – 12:29AM
12:30AM – 12:59AM
1:00AM – 1:29AM
1:30AM – 1:59AM
2:00AM – 2:29AM
2:30AM – 2:59AM
3:00AM – 3:29AM
3:30AM – 3:59AM
4:00AM – 4:29AM
4:30AM – 4:59AM
5:00AM – 5:29AM
5:30AM – 5:59AM
6:00AM – 6:29AM
6:30AM – 6:59AM
7:00AM – 7:29AM
7:30AM – 7:59AM
8:00AM – 8:29AM
8:30AM – 8:59AM
9:00AM – 9:29AM
9:30AM – 9:59AM
10:00AM – 10:29AM
10:30AM – 10:59AM
11:00AM – 11:29AM
11:30AM – 11:59AM
12:00PM - 12:29PM
12:30PM - 1:00PM
1:30PM - 1:59PM
2:00PM - 2:29PM
2:30PM - 2:59PM
3:00PM - 3:29PM
3:30PM - 3:59PM
4:00PM - 4:29PM
4:30PM - 4:59PM
5:00PM - 5:29PM
5:30PM - 5:59PM
6:00PM - 6:29PM
6:30PM - 6:59PM

7:30PM - 7:59PM
8:00PM - 8:29PM
8:30PM - 8:59PM
9:00PM - 9:29PM
9:30PM - 9:59PM
10:00PM - 10:29PM
10:30PM - 10:59PM
11:00PM - 11:29PM
11:30PM - 11:59PM 

...

Note

we don't need netid as input argument. confirm date format? ; at last meeting Rod said he would prefer a four-digit year. - db692

Existing Oracle API: FUNCTION expireCBAccount (a_node_name    IN VARCHAR2,   a_expire_date  IN DATE)

New ServiceNow API: FUNCTION expireCBAccountViaSN (a_node_name    IN VARCHAR2,   a_expire_date  IN DATE)  RETURN NUMBER

Info

You must pass in an Oracle date.  No time component.  WebMethods must convert whatever input is received from ServiceNow.  4 digit year is STRONGLY recommended. - rng3

Delete method needs to return an error code indicating whether or not the delete request was accepted, and for errors should indicate the problem with the data.

...

Note

What is a_service_cd, and how should it be formatted? a_service_cd='CB'


getNodeList()

Arguments for getNodeList:
netid of owner

...

Note

Need to know the exact flags to set. We want only Active nodes, owned by the netid. What is the flag we should set for status_cd?


Info

If you want a list of active nodes, use "status_cd in ('A', RL').

RA has not been created yet, so you can't perform any action on it.

L, RD and D are already closed, so you can't take further action on them.

 

 

Sample nodename strings

  • "tanner,cooper,radar"
  • "" (empty set)
  • "zuse"

...

Arguments for update:
charge_code (gathered from a previous call to getSrvcChargeInfo() )
nodename (needs to be unique, and already exist)

client category (DS,MW,WS)
Client OS (Windows, Mac, Unix)
interval (backup time, or never)
PTAEO, passed as five separate strings

...

update method needs to return an error code indicating whether or not the add request was accepted, and for errors should indicate the problem with the data.

Info

Updates are only applicable to update the PTAEO. End users cannot/do not need to select the Charge Code as that happens automatically.

Accounts using a Charge Code of 1 may have the PTAEO changed. All others should rejected because there is nothing to change.

Outstanding questions

  1. What's a charge code (name and / or number)? Do I need to pass that with everything I send back and forth to netbill? ANSWER: It's a string NUMBER that is returned from getSrvcChargeInfo(). Push it back to NetAdmin on update() and add() methods.  The interface also refers to this as an agreement code.  
  2. Why would we care whether or not somebody is a student? Is there relevance to billing? ServiceNow already knows this information, and apparently NetBill already knows also. Do we really need to pass that back and forth? ANSWER: The answer is complicated. The short answer is that a student shouldn't own a backup system, but they may do so on behalf of a staff member, and they may also own one if they were a staff member and then their status changed to student. So the long answer is no, we don't care.

...

Note

Backeberg heard back from Norm Morales that he needs to know exactly which methods should be used for the purposes of granting rights on ACS1,ACS2,ACS3. Perhaps somebody from Rod's group can meet with Norm to work this out.

Info

Rod's group will grant appropriate access as part of our deployment. All Norman needs to know is that the account will not own any objects.

Rod Gustavson's group

We need Rod's group to review the API as specified and confirm that this seems to be complete and sufficient for CRUD methods on these records.

We need new interface to NetBill to conform with the API as specified here. Note, that it seems the existing methods are sufficient. Instead, we just need to build up WebMethods API to talk to the existing design. There doesn't need to be substantial rework here.

Info

We only need one new method for add. We will keep the other methods in place so they will continue to operate.

Minor changes are needed to other methods within NetAdmin to support the additional default server logic.

New rows must be added to the timeslots for each server.

New servers must be added to the servers table.

Deployment scripts must be created.

Unit testing of any modified procedure or any procedure relying upon a modified procedure will be done.

 

Kazi's group.

We need new Webmethods SOAP / XML api to bridge between the Oracle environment of NetBill and the ServiceNow SOAP interface. Kazi's group cannot begin until Rod's work is nearly completed. Kazi will need method names to bind to in Oracle.

...

Create and maintain specification for API. Request Oracle account from DBAs. Create and maintain task list for backup automation project.

Info

Test plans and scripts must be created and executed in each environment.

Service Introduction tasks must be completed.